ranges

mort1703

Active Member
Joined
Sep 13, 2008
Messages
265
LineCounter - counts using a for .. loop the number for rows holding data, value returned as a number

RowCounter - counts using a for .. loop the number of columns holding data, value returned as a number

now using these values I would like to generate a cell ref.

for example
LineCounter = 20
RowCounter = 5

cellref = E20

any ideas on how I could do this would appreciated
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
How about:

Cells(LineCounter, RowCounter).Address

But shouldn't it be RowCounter and ColumnCounter for clarity?

HTH,
 

mort1703

Active Member
Joined
Sep 13, 2008
Messages
265
very good point on the variable names

I have used your formula to create a variable called CELLREF.

CELLREF is now holding a value of $V$38

how do I combine the value held in CELLREF in a range syntax

In this example I need to cover a range covering A1 .. CELLREF
 

Watch MrExcel Video

Forum statistics

Threads
1,122,818
Messages
5,598,280
Members
414,223
Latest member
Accountant2B

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top