Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA
Can someone tell me what do i declare as a variant? i have a code to pupolate
data from one workbook in to the second. i have like 10 columns in my workbook 2 and like 25 columns in workbook 1. i am trying to get the data for the 10 columns in workbook 2 from the same cells in workbook 1. i got this code off the internet but i dunno how to declare variants and ranges...can someone help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA
You should avoid variants and you don't need them here. I'm not sure why you
need a VBA macro to do this but the following code will work. Just replace the range reference to whatever you need it to be. This copies the data from the first 10 rows and columns in sheet1 to the first 10 rows and columns in sheet2. ActiveWorkbook.Worksheets(1).Range("A1:J10").Copy _ ActiveWorkbook.Worksheets(2).Range("A1:J10") "nick" wrote: Can someone tell me what do i declare as a variant? i have a code to pupolate data from one workbook in to the second. i have like 10 columns in my workbook 2 and like 25 columns in workbook 1. i am trying to get the data for the 10 columns in workbook 2 from the same cells in workbook 1. i got this code off the internet but i dunno how to declare variants and ranges...can someone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|