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!

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

Variable sized ranges 1

Status
Not open for further replies.
izzyq

izzyq

MIS
Mar 13, 2002
38
CA
When using the Range(activeCell, ActiveCell.End(xlDown)).Select action which selects the active cell down to the down to the non-empty cell, do i add on to it move back up one to an empty cell. What I need to accomplish is select a range of blank cells sandwiched between to sets of data. Help Me Obi Wan Kenobi, You're My Only Hope.
 
Sort by date Sort by votes

What you're doing is coding something that mimics user key-presses...

What you might try is recording a macro that does exactly what you want the VBA to accomplish, and then see what Excel creates for you.
 
Upvote 0 Downvote
Does

Range(ActiveCell, ActiveCell.End(xlDown)).SpecialCells(xlCellTypeBlanks).Select

help ?

AC
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Variable in Pivot Table 1
Replies
4
Views
141
arvarr
arvarr
remeng
  • Locked
  • Question
Capture active macro name as a variable 1
Replies
16
Views
268
Andrzejek
Andrzejek
MattGreer
  • Locked
  • Question
Using A Boolean in a Calc, and setting a variable = "0" 3
Replies
6
Views
119
SkipVought
S
kjv1611
  • Locked
  • Question
Excel Ranges in VBA: Reference same row of NamedRange2 based on current location within NamedRange1 1
Replies
4
Views
83
kjv1611
kjv1611
telephoto
  • Locked
  • Question
Pause vba and select cell as value for variable 1
Replies
8
Views
143
telephoto
telephoto

Part and Inventory Search

Sponsor

Back
Top