View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Excel VBA - Varible number rows

Hi
you may post your existing macro and describe what you're trying to
achieve. In most cases there's no need for selecting a range

--
Regards
Frank Kabel
Frankfurt, Germany


Hello

I am using Ctl F to find end ( marked by = ) of a block of rows in a
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 the
block changes.

Any ideas to solve would be appreciated.

Louis


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