CreateRange in Excel with vbs/asp

[bastienk]

How do i create the range for a certain area in the excel spreadsheet? I can get the width and height of the range with

intCols    = xlsheet.UsedRange.Columns.Count
lngNumRows = xlsheet.UsedRange.Rows.Count

I am just unsure as to how to syntactically create the statement needed.

TIA


Bastien

Cat, the other other white meat

 

[PHV]

Which Range ?
Something like this ?
Set myRange=xlsheet.Range("A1:C5")
With xlsheet
Set myRange=.Range(.Cells(BegRow,BegCol),.Cells(EndRow,EndCol))
End With
Anyway, the correct size of the used range is:
With xlsheet.UsedRange
intCols = .Columns.Count - .Column + 1
lngNumRows = .Rows.Count - .Row + 1
End With

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884