Assigning cell address components to variables

C

Conan Kelly

Hello All,

I've been looking through the VBA help to find the answer to this with no
luck.

Can I assign the Row number and Cell number for the currently sellected cell
to individual variables for use later in formulas and range selection. For
example, I have a large list. I move to the end of the list by holding down
[Ctrl] and then the down arrow. This is where I would like to store the row
number into a variable. I would then move to a predetermined column in that
row and enter formulas using these variables.

If I can assign these to variables, do I have to be concerned with the cell
address format I use in my formulas or can these variables automaticaly
converted to the different address formats?

Thanks for any help anyone can provide,

Conan
 
A

Arvi Laanemets

Hi

......
CurrRow = ActiveCell.Row
CurrCol = ActiveCell.Column
LastRow = ActiveSheet.UsedRange.Rows.Count
 

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

Declaring Variables 3
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Copy cell data and assigning to variables 2
Evaluating 3 Variables 6
Best Practice for Public Variables for Column Headings 2
Sum Forula using variables 3
Assigning cell values to variables 3
Assigning a cell address to a variable 1

Top