Column as a variable

[djblois1]

I have this code that I am updating - I used to use a Constant for the column number. However, this led me to write the code 30 times for different customers. Now I am using a variable for the code but I cannot figure out how to change the Column number to use the variable:

Please Login or Register  to view this content.

The variable name is lgColumn. How do I replace the column number with this variable?

[MarvinP]

Hi,

I've started using Cells(row, column) instead of Range in my VBA. This allows me to increment the column number.

Then to address all cells in a range you can set two sets of counters like:

Please Login or Register  to view this content.

[djblois1]

Thank you for your help but I do not want to use a loop. It takes longer to run. I know it is possible to populate the whole column in one shot - I just do not know how.

[snb]

Please tell me how much longer it will take using a loop....

Please Login or Register  to view this content.

[djblois1]

With a loop it depends on the amount of rows. When you loop through, it does each row as a different operation as opposed to the other method will do the whole column at once. I cannot tell you exact time difference because it matters on a lot of different things.

[snb]

Yes I know it's indiscernable: ergo peanuts.