Return actual range not cell value in variable

R

Richhall

Hi, forgive my poor coding, as I haven't learnt VBA at all. How do I
ger rowendrange and nowrow to return the cell range instead of the
cell value?

Dim rowend As String
Dim rowendrange As Range
Dim nowrow As Range
Dim lastrow As Range

If Me.TextBox1.Value = "" Then
rowend = 0
Else
rowend = Me.TextBox1.Value
End If

rowendrange = ActiveCell.Offset(rowend, 0).Range
nowrow = ActiveCell.Offset(0, -2).Range

Me.TextBox2.Value = nowrow
Me.TextBox3.Value=rowendrange

Thanks in advance

Rich
 
L

Luke M

I think when you are saying "range" you actually mean "address". In which
case, change the two lines to:

rowendrange = ActiveCell.Offset(rowend, 0).Address
nowrow = ActiveCell.Offset(0, -2).Address
 

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

Replacing 0 value with empty 8
Loop hits Row 8 and goes to End Sub?? 9
Select used range 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Unknown error in function, and how to return value? 4
modify existing macro 2
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul 2
If any cell in a range has a value, return "True" 1

Top