python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - paste

Pasting range across workbooks

I am trying to copy/paste a range to another workbook. I am using variables to define the cells/ranges because the destination range changes on a daily basis. This method worked for pasting cells only...
test-img

Anthony L

excel

vba

copy

paste

Votes: 0

Answers: 2

Latest Answer

Should be close: Sub pasteVariableRange() Dim x1 As Long, x2 As Long, y As Long 'prefer Long over Integer Dim wb As Workbook, a As Range, wsSrc As Worksheet Set wsSrc = ThisWorkb...
test-img

Tim Williams

The value obtained by Async Clipboard API is different from the value obtained from PasteEvent

The content obtained by using the Async Clipboard API and the content obtained by pasting the data copied from Excel with Ctrl + V are different. Below is the code using the AsyncClipboard API, // // ...
test-img

Hiroshi H

javascript

excel

clipboard

paste

Votes: 0

Answers: 0

How can I paste ranges using variable references?

I am attempting to paste several ranges from one workbook to another using variables as the references. I was successful in running this for individual cells, but I think my syntax is wrong now that I...
test-img

Anthony L

excel

vba

copy

range

paste

Votes: 0

Answers: 0

Concatenate columns in R, but only keep separator if value exists

Does anyone know of a method in R to concatenate n columns but only keep the separator if there is a value in that row? If you run the example below: df <- data.frame( name1 = c(&...
test-img

John Conor

r

dataframe

concatenation

paste

separator

Votes: 0

Answers: 1

Latest Answer

library(dplyr) library(tidyr) df %>% mutate_all(na_if,"") %>% unite("names", everything(), sep = ";", remove = F, na.rm = T) #> names name1 na...
test-img

M--&#223;ţřịƙ&#239;&#241;ĝ

Posts

Questions

Blogs

Jobs