Movement

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

Guest

Hello,

How can I move to the cell in column "A" on the row that I
am currently on. I want to be able to move to column A
from any row and the row will change.

Looking for something like:

Range("A" & Row).select

This doesn't work, but is something similar possible
 
Hi,

Try:
Cells(ActiveCell.row, 1).Seleect

or

ActiveCell.EntireRow.Cells(1).Select


However, you rarely need to physically select a cell. Most operations can be
effected by referring to the cell.
 
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

Import multiple workbooks to current workbook in specified row number 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
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Eliminate blanks while copy row and transpose 11
Excel Help to copy information from one row at a time to another sheet 1
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Transpose?? 6
lastrow function help 6

Back
Top