View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
louismx louismx is offline
external usenet poster
 
Posts: 1
Default Excel VBA - Varible number rows

Hello

I am using Ctl F to find end ( marked by = ) of a block of rows in
spread sheet. I then use CTL HOME to select from the end to beginning.

I want to use this command as a macro.
The blocks have a variable number of rows ranging 6 to 20 rows.
However when I run as macro it fails when the number of rows in th
block changes.

Any ideas to solve would be appreciated.

Loui

--
Message posted from http://www.ExcelForum.com