| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add an integer to an existing integer? | Excel Worksheet Functions | |||
| Dynamic Chart with OFFSET defined name not working | Charts and Charting in Excel | |||
| Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
| How do I offset a row of cells a defined number of columes? | Excel Worksheet Functions | |||
| Offset in User Defined Function | Excel Programming | |||
Threaded Mode
