Use cell value as column offset

[Tiger9136]

Please Help,

I have been searching the internet for an answer but cannot get what I am looking for.

Here is what I need to know how to do:

ActiveCell.Offset (0, E40).Select
ActiveCell.Offset (0, "The value of cell E40").select

It seems so simple but I have not figured out a solution.

TIA.

 

[Joe4]

It looks like you are trying to do it in VBA. Remember, in VBA, if you type in E40 by itself, it is looking for a variable named "E40".
To reference the range "E40", you need to use Range("E40"), or a range variable set to that range, i.e.

[COLOR=#333333]ActiveCell.Offset (0, Range("E40")).Select[/COLOR]

 

[Tiger9136]

Thanks, this helped me a bunch!

 

[Joe4]

You are welcome.