Using variables in a range.select statement

[lday75]

I have posted this in a different thread, however I cannot find that thread in a search and the site crashed at the same time I posted, so I am reposting.
I have the following code which works fine:

Please Login or Register  to view this content.

HOWEVER, when I plug variables into this rather than cell addresses, I get method of object _Global failed error, it errors out on the Range("StC:ACol" & LastRow).Selec line of code. Below is the code that fails

Please Login or Register  to view this content.

Any Thoughts?

[Xer2]

Ranges with variables are possible, but VBA is picky about the way it wants it.
I believe I know what the issue is, but can you provide a sample with some fake data that I could manipulate?

[lday75]

Unfortunately no, I can only post even just pieces of code due to the nature of the data, client financial data. Plus this involves a VLOOKUP that pulls from 3 different books, so to have functionality samples it would involve 4 files and replacing a ton of data with pseudo data. My apologies. What is throwing me is that the first Range line also produced the same error and then I removed the " " from around the variable name and it went past that.

Please Login or Register  to view this content.

changed from

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

[Xer2]

Is it only the:

Please Login or Register  to view this content.

that is giving you the problem or are all three (3) where you use the variable?

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

[lday75]

Xer2 - You ROCK. Thank you so much, this did the trick, works perfectly.

[Xer2]

Thank you, and you're welcome. I'm just glad to help.