next cell

  • Thread starter Thread starter robert_woodie
  • Start date Start date
R

robert_woodie

if i have cell a1 selected in visual basic code what is the line of code
to select the cell below it......ie add one to the row number?

im sure this is simple!!
cheers
robert
 
Robert,

It's as simple as

Activecell.Offset(1,0).Select

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
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

Continuous Invoice Nos. 3
select cell by variable name 6
How To Have A Cell Be Blank If... 2
Code to format cells on several worksheets 2
Help with Conditional Formatting 1
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
sorting two columns of merged cells 1

Back
Top