Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CTL F and CTL Home Macro fails

Status
Not open for further replies.

louismx

Technical User
May 29, 2004
5
0
0
IE
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
 
when I run as macro it fails
Any chance you could post the error message or the unexpected behaviour ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top