MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro recording, selecting rolls based on found data

Posted by Dan on May 01, 2000 10:24 AM

I have many many route sheets to edit. The problem is that the sheets are not standard even though they contain the same information. I want to insert a row below a certain value but that value is present on different rows on different worksheets. It may be on row 26 on one and 28 on the next. I have tried to record a macro that finds that value and then on the next row inserts a line but it assigns that row # to the macro. Example: finds value on row 25, the next line reads something similar to...

Selection.Insert Shift:=xlDown

Any thoughts? I hope I've made things clear. If not I'll amend additional info.


Posted by Celia on May 01, 2000 4:31 PM

Assuming that your macro can locate and select the value regardless of what row it is on (if not, please advise), then instead of "Rows("26:26").Select" use the following code :-



Posted by Daniel on May 02, 2000 11:26 AM

Thanks Celia!!!