Retrieving Value From Column A

  • Thread starter Thread starter Kelvin Clayson
  • Start date Start date
K

Kelvin Clayson

Hi all -

Can anyone clue me in as to how I could get the value of a cell in column A
to the active cell? E.g. if the active cell is C116, how can I read the
value in A116?

I've tried using the Offset property, but this seems to require the exact
number of columns, whereas the active cell could be in any row.

Many thanks for all/any help - I'm almost there with this!!

Cheers


Kelvin
 
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

counting number of columns 1
InputBox for column letter problem 2
Conditional listbox cell populating 4
Transfer array element offset value to a matched value 3
Column number of last column that returns value ignore formulas 8
Named cells in an array to a column and to a row 3
How to locate a cell with dynamic column value 2
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

Back
Top