Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
Two questions (for now!) 1. Is there any reason when recording a macro that I should NOT use shortcut keys - either Ctrl + C or right-click and delete row, for example - as opposed to using the menus? 2. When VBA code refers to relative cells by using offset, for example ActiveCell.Offset(1,0).Range("A1:A3").Select I know that the offset means one row down in same column (from active cell); I assume the rest means that from that cell (let's say it's cell A20) select what it deems as A1:A3, which is really A20:A22. Thanks! -- Thanks! Dee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Two Quick Questions | Excel Programming | |||
Two Quick Questions | Excel Programming | |||
Two Quick Questions | Excel Programming | |||
Two Quick Questions | Excel Programming | |||
2 quick questions | Excel Programming |