View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BrookStevenson BrookStevenson is offline
external usenet poster
 
Posts: 2
Default Can I use a defined integer in an OFFSET method?

I have a looped macro for opening files and copy/paste some info from them.
In order to keep this info from overwriting I want to use an offset. Here is
a what I need:

Dim y As Integer
y = (D152 * 2)
ActiveCell.Offset(0, y).Select

I'm new to VBA so I not sure if this is possible, but this was the best
solution I could come up with... but still doesn't selct an offested cell
(D152=COUNT(O151:DL151))