Excel VBA - Varible number rows

  • Thread starter Thread starter louismx
  • Start date Start date
L

louismx

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
 
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
 
Ctrl+Home goes to A1 for me

Dim rng as Range
set rng = Range(Range("A1"),Cells.find("="))

rng.Select

Another possibility

Dim rng as Range
set rng = cells.find("=")
rng.CurrentRegion.Select
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA CreateNames (ignores last 5 rows?) 6
Return last row no. of column with blanks at top 7
Modify working code to expand the output. 5
Copy a range instead of just one row but with condition 8
Iteratively delete rows from a spreadsheet 3
Code to Resize a variable number of rows including target 7
i = row number of last occurance of duplicate string Column A 4
Copy to a mid column range Row 10 - Row 20 4

Back
Top