Variables to Optimize VBA Macro

[valverde311]

Hi all,

I wrote a lengthy macro that copies a number of cells from one workbook to another and I reference the cells via the syntax below....

Since I'm constantly repeating the bold portion, I'm wondering if setting a variable = to the bold portion would speed things up.


Workbooks("Master File.xls").Sheets(1).Cells(71, 4).Value =



Both a) and b) were not working when I tried...



a) Dim Master as String
b) Dim Master as Worksheets

Set Master = Workbooks("Master File.xls").Sheets(1)







Can anyone help?

 

[Norie]

Use the second one but remove the s after Worksheet.

 

[ISY]

Hallo

Sure you can improve the code, you can better describe the commands that you want to improve with a practical example?
There may be several solutions to your question
How many cells are involved, which cycle you get

Pending greetings

 

[Norie]

Meant to add - using a variable such as this might not speed the code up.

What it'll definitely do is make the code easier to follow and that might help in pinpointing anything that's slowing things down.