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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HELP!! Highlight Range using string 1

Status
Not open for further replies.
01491

01491

ISP
Joined
Oct 30, 2001
Messages
17
Location
GB
I'm trying to highlight the range from ActiveCell to Activecell+(value in the activecell).

Doesn't like:

Range(ActiveCell:(ActiveCell.Offset(ActiveCell.Value,0)).select


Any help, much appreciated.
 
Sort by date Sort by votes
Does,

Range(ActiveCell,ActiveCell.Offset(ActiveCell.Value,0)).Select

Do it.

If you just want to highlight it, you may not need to selct it.

Range(ActiveCell,ActiveCell.Offset(ActiveCell.Value,0)).Interior.colorindex = 6

would apply a coloring to the range.

AC
 
Upvote 0 Downvote
Brilliant - Thanks a lot!!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

thanhthanh12
  • Locked
  • Question Question
Help vba
Replies
3
Views
896
combo
combo
SLW89
  • Locked
  • Question Question
VBA newbie needs help
Replies
4
Views
821
Andrzejek
Andrzejek
remeng
  • Locked
  • Question Question
Using Err.Raise question
Replies
2
Views
2K
mintjulep
M
dgillz
  • Locked
  • Question Question
Back coloring an entire row if a duplicate is found in a dynamic range
Replies
18
Views
1K
SkipVought
S
aldi07
  • Locked
  • Question Question
update a front-end databases with a new release using vba
Replies
2
Views
548
aldi07
aldi07

Part and Inventory Search

Sponsor

Back
Top