Dynamically build call reference

[UHsoccer]

I need to dynamically change the cell reference based on the month of the year that is being requested

Example
Range("G9").Select (is for Dec)
Range("I9").Select (is for Jan)

I need to do something like

if month = "Dec" then var = "G"
if month = "Jan" then var = "I"

How do I use "var" in the Range statement

 

[Juan Pablo González]

Use something like

Range(var & "9").Value = mystuff

 

[bjwillingham]

Just a word of advice. I would not recomend hard coding a range address reference in a macro. If you ever move formulas or insert colums or rows the macro will mess you up big time.

I would suggets naming the top cell and then using offset references from the name. The name will move if rows or columns are inserted and the macro will continue to perform as expected.


"Think Ahead, Be Prepared"

 

[UHsoccer]

Thanks for the help, it works