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))
|