| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
activecell.offset does not work
Hi Hans,
As Frank indicated you do not need to change the selection and stating a purpose might help getting the answer you want. But I think what you were doing wrong was switching row and column in the OFFSET(row,column) ActiveCell.Offset(0, 1).Select I think you wanted to select a cell on the next row, not the next column, in which case: ActiveCell.Offset(1,0).Select --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "hans" wrotebl... Has anyone an idea of what I am doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ActiveCell.Offset Question | New Users to Excel | |||
| If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
| Sum Activecell Offset Problem | Excel Worksheet Functions | |||
| ActiveCell.Offset w/ VBA | Excel Programming | |||
| activecell offset | Excel Programming | |||
Threaded Mode
