Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros
I'm very new at macros. In creating the macro, I want to go to the cell that
has the words "END OF REPORT" and then add rows. I got itto add the rows, but I don't know how to get it to always go to "END OF REPORT", which will be on different line every time it's modified. (But always in Column A). Thanks for any help you can provide. KK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros
Have a look in vba help for FIND
Sub findtext() With Cells(Columns(1).Find("xx").Row, 1) ..Select '.Rows.Insert 'or ..Offset(1).Rows.Insert End With End Sub -- Don Guillett SalesAid Software "kleivakat" wrote in message ... I'm very new at macros. In creating the macro, I want to go to the cell that has the words "END OF REPORT" and then add rows. I got itto add the rows, but I don't know how to get it to always go to "END OF REPORT", which will be on different line every time it's modified. (But always in Column A). Thanks for any help you can provide. KK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
calling a series macros with a marco | Excel Discussion (Misc queries) | |||
Deleting Macros | Excel Worksheet Functions | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) |