Previous Topic Next Topic

Macro Help

Solved/Closed
futurepsych92 Posts 8 Registration date Monday January 4, 2016 Status Member Last seen February 19, 2016 - Feb 19, 2016 at 11:31 AM
futurepsych92 Posts 8 Registration date Monday January 4, 2016 Status Member Last seen February 19, 2016 - Feb 19, 2016 at 09:41 PM
Greetings fellow users!

I am in need of some assistance:


Recently, I have created a macro in which I need to copy 100+ variables from one sheet to another. Due to various constraints, I have found it easiest to paste them individually (see example below). I was just wondering if there is a limit on how many variables Excel can hold in memory. Thank you so much in advance.

Sheets(“Sheet1”).activate
Var1 = cells(1,3)
Var2 = cells (1, 6)
Var3 = cells(1,8)
Sheets(“Sheet2”).activate
Cells(1,1) = Var1
Cells(1,2) = Var2
Cells(1,3) = Var3

1 response

Answer 1 / 1
RayH
Feb 19, 2016 at 09:18 PM
Rather than using variables why not consider this: 

Sheets("Sheet2").Cells(1, 1) = Sheets("Sheet1").Cells(1, 3)
Sheets("Sheet2").Cells(1, 2) = Sheets("Sheet1").Cells(1, 6)
Sheets("Sheet2").Cells(1, 3) = Sheets("Sheet1").Cells(1, 8)
0
futurepsych92 Posts 8 Registration date Monday January 4, 2016 Status Member Last seen February 19, 2016
Feb 19, 2016 at 09:41 PM
I will try that--thanks!
0

Similar discussions

Automatically Run Macro from a calculated cell value change
smiller -
TrowaD -

1 response
Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
Execute Macro On Calculated Cell change
Notar -
rizvisa1 -

5 responses
How to convert number into text in Excel
boratechandu -
Raj -

9 responses
Macro to insert row based on variable cell value (text)
deadxcell -
vcoolio -

1 response