macro to refer to the cell content

[cstarnite]

I have a spreadsheet that I update weekly. Each column contains the new week. In excel I created a lookup to take the current data date and find the input column/row (e.g. cell b5 results equal CB9 the range value). In my macro range(" ").select... I want the value in cell b5 to be my value for the range in my macro range("CB9").select. Does that make sense?

 

[Smitty]

Welcome to the Board!

You should probably post your code, especially if you're doing a lot of selecting, which is generally unnecessary.

In the meantime is this what you want:

Range([B5]).Select

Or if you have to refer to another sheet:

Range(Sheets("Sheet1").Range("B5").Value).Select

Hope that helps,

Smitty

 

[cstarnite]

That worked...I appreciate your help and next time I'll post the code.

 

[Boller]

Or if you have to refer to another sheet:

Range(Sheets("Sheet1").Range("B5").Value).Select

Would probably need to be :-

ActiveSheet.Range(Sheets("Sheet1").Range("B5").Value).Select