Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I wish I knew more about macros, I know someone will help me, please don't
laugh at me though :). Here's my thing. I have supplied the small macro I have, IF i inserted 10 new rows in my worksheet the macro won't work anymore because it is looking for the data in cell F15 and it isn't there anymoe because I have inserted new lines, how do I telkl the macro to go to cell F25. Secondly I always need the info in the original F15 cell, however I will not alwas add 10 rows, maybe sometimes it will be 8, therefore I need the macro to go to the new cell anfter I have inserted the rows. Thanks in advance, since it is the 1st time I post here, I hope I wasn't too long and was clear Oh yes I use Office 2003. Sub Macro1() ' ' Macro1 Macro ' Macro recorded 28/12/2004 by Serge ' ' Range("F15").Select Selection.Copy Range("A1").Select ActiveSheet.Paste End Sub -- Dell 8200. nVidia Ti 4200. 64mgs RAM 512mgs. P4, 2.26 Ghz. OS, XP Home. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Embarrassing question about lookup. | Excel Worksheet Functions | |||
Looking for a macro/function in an excel spreadsheet (Help) | Excel Worksheet Functions | |||
Using Macro function in Excel | Excel Discussion (Misc queries) | |||
Macro execution from Excel IF function | Excel Programming | |||
Excel Macro for VLookup Function | Excel Programming |