Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My knowledge of Macros is that I know how to record them and not much else!
I want to pick a cell and copy it down 3 rows - and then delete the original cells. The next month I need to pick the new cells and then copy them down another 3 cells. I can use ctrl down arrow to find the first bit of data but when I select it it gives an absolute range Range("E6:F6").Select This means the next month it picks up the cells I deleted earlier - not the new value that is now 3 cells lower. How can I change this so it doesn't have an absolute reference and will simply pick up the first 2 cells it comes across? Thanks for any help with this... Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumproduct absolute cell references | Excel Discussion (Misc queries) | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
Cell Absolute $ References Keep Changing themselves | Excel Discussion (Misc queries) | |||
Absolute references in a cell | Excel Discussion (Misc queries) | |||
Absolute References in cell formula | Excel Worksheet Functions |