Unhide

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am using Excel VBA.

Currently I have several rows hidden between various unhidden rows. When I
normally use the vba code:

range(selection,selection.end(xlup)).select

The range includes everything up to the first empty cell above the current
cell. However if the first empty cell is hidden it skips over them and goes
to the first unhidden empty cell. How can I get the range to stop at the
first empty cell no matter if it is hidden or not.

Thank You,
 
Sub lrh()'use cells to find last on ws
MsgBox Columns(1).Find("*", searchdirection:=xlPrevious).Row
End Sub
 
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

Hiding and unhiding rows with if statement macro 1
Expand and collapse rows 7
Sum a variable length column 1
hide and unhide rows 5
Dynamic Offset from an Application.Goto cell = Date or Time 10
Move Cursor Up 8
Hide and unhide rows for multiple areas 6
Code to Unhide set of rows (SC). 3

Back
Top