Range with variable columns

[GrayMPA]

I can use ranges for variable rows, but cannot figure out how to use variable columns.

For variable rows, I use:

lastrow = Range("b65536").End(xlUp).Row
Range("B11:H" & lastrow).Select

I am trying to set the data for a graph using a variable number of columns
using this form:

lastcol = Cells(2, 256).End(xlToLeft).Column

but this errors out:
mydataRange = Range(Cells(2, 22), Cells(3, lastcol))

I have tried Set command, no luck.

 

[NateO]

Hello,

You definitely want to use Set, the following works for me:

Sub foo()
Dim myDataRange As Range
Dim lastCol As Long
lastCol = Cells(2, 256).End(xlToLeft).Column
Set myDataRange = Range(Cells(2, 22), Cells(3, lastCol))
MsgBox myDataRange.Address(0, 0)
End Sub

Yes-no?

 

[GrayMPA]

Thanks vry much

I had the right idea, just had a "." instead of a ",". Couldn't find it until I put yours text up next to mine.