G
Guest
Using Excel 2003, I have a macro that does everything except for holding down
the shift key and using the down arrow key.
I need to copy three rows, C5:C7. Starting in C5, the macro needs to SHIFT,
DOWN DOWN to highlight the three cells so they can be copied. (I can’t use
end-down because C6 & C7 may be blank.)
Can you show me an example of how the SHIFT command and the DOWN command
should be written into my macro?
Thank you very much,
John
the shift key and using the down arrow key.
I need to copy three rows, C5:C7. Starting in C5, the macro needs to SHIFT,
DOWN DOWN to highlight the three cells so they can be copied. (I can’t use
end-down because C6 & C7 may be blank.)
Can you show me an example of how the SHIFT command and the DOWN command
should be written into my macro?
Thank you very much,
John