| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro that loops till end of worksheet
Hello,
I'm trying to create a macro that based on a search, inserts a pagebreak. It need to do this till end of worksheet - of which i won't know, being this worksheet will continually grow. Any suggestions - thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro that loops till end of worksheet
Hi
for getting the lastrow see: http://www.xldynamic.com/source/xld.LastValue.html#vba -- Regards Frank Kabel Frankfurt, Germany "Nadiya" schrieb im Newsbeitrag ... Hello, I'm trying to create a macro that based on a search, inserts a pagebreak. It need to do this till end of worksheet - of which i won't know, being this worksheet will continually grow. Any suggestions - thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro that loops till end of worksheet
See answer to your first posting of this question.
-- Regards, Tom Ogilvy "Nadiya" wrote in message ... Hello, I'm trying to create a macro that based on a search, inserts a pagebreak. It need to do this till end of worksheet - of which i won't know, being this worksheet will continually grow. Any suggestions - thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to loop till end of page | Excel Programming | |||
| Force Macro to wait till Refreshall is done | Excel Programming | |||
| Vlookup macro that returns data from worksheet, then Loops | Excel Programming | |||
| Vlookup macro that returns data from worksheet, then Loops | Excel Programming | |||
| Macro to nsert value from table, then next value, till done | Excel Programming | |||
Linear Mode
