Range Using Custom Sheet Name

[medberg]

Hey Everyone,

I am trying to use a custom sheet name in a range and cannot get it to work. Here is what I have:

Range(Sheets("Add A Record") & "!" & Sheets("Add A Record").Cells(8, upperLeftC + columnC + 1).Address)

In this example the sheet name is obviously "Add A Record". Any help would be greatly appreciated. Thanks!

 

[Rick Rothstein]

Range(Sheets("Add A Record") & "!" & Sheets("Add A Record").Cells(8, upperLeftC + columnC + 1).Address)

It looks like you are trying to use Excel worksheet formula constructions on VB objects. While I can't be sure since you didn't show us value for your variables or the cell's content or what you wanted from them, but I think this might be what you are looking for...

Sheets("Add A Record").Cells(8, upperLeftC + columnC + 1).Value

 

[medberg]

Thanks for your reply, I appreciate it. I cannot show more code because it is confidential although I wish I could. What you suggested worked for the most part, I just had to make sure the appropriate sheet was activated first. Thanks again!