Embed the value in a cell within the offset command

B

biff

ActiveCell.Offset(x).Activate


Offset works great when I put a value in for "x", but how do I make it look up the value in a worksheet cell "a1" and use that as the value for "x"
thanks in advance
 
K

Kevin Stecyk

biff,

ActiveCell.Offset(Range("A1")).Activate

Regards,
Kevin


biff said:
ActiveCell.Offset(x).Activate


Offset works great when I put a value in for "x", but how do I make it
Click to expand...
look up the value in a worksheet cell "a1" and use that as the value for "x"
 
K

Kevin Stecyk

ActiveCell.Offset(Range("A1").Value).Activate

Now I match Dave Peterson's answer in form given earlier this evening.

:)

Regards,
Kevin
 

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 Coding Help for Beginner 0
Mapping integers to strings 6
Event recognition. 11
Word Template and Normal Style 1
For Eachcell in Range tranpose comma seperated values to a list in D 4
Embed the same Excel multiple times 0
SUMIF "value if false" not working 2
Vlookup to reference offset 1

Top