variable fill range

I still have the problem (Application-defined or object-defined error. at:
rowCount = ActiveSheet.Range(name2).Value)

However, “Range” comes from a different worksheet, “BinSize”. (“Range” IS a global named range)

If worksheet "BinSize" is selected in excel and the code is ran, it works fine. If the correct worksheet, Htestc, is selected the error occurs.

I tried changing the line to:

rowCount = ActiveWorkbook.Range(name2).Value

and get: “Object doesn't support this property or method (Error 438)”

Im getting beat up by somethin that seems pretty simple

Replace this line of code:

rowCount = ActiveSheet.Range(name2).Value

with this line of code:

rowCount = ActiveWorkbook.Worksheets("BinSize").Range(name2).Value

Replace this line of code:

varRange = ActiveSheet.Cells(37, 1).Address & ":" & Cells((37 + Range(name2).Value), 1).Address

with this line of code:

varRange = ActiveSheet.Cells(37, 1).Address & ":" & Cells((37 + RowCount), 1).Address

Hope this helps,
theDude

yes, it works.
Thanks for the help and education!