Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Usedrange
Hello
How can I get the usedrange from a sheet in a closed workbook? This is how I am getting the values: With ActiveSheet.Range(cellrange) .FormulaArray = "='" & fpath & "\[" & fname & "]" _ & sname & "'!" & cellrange End With Where cellrange right now is a variable that contains a range that is hardcoded. I want to be able to find the usedrange in the closed workbook, to pass it as a variable to this sub from the calling sub. Thank you Terry V |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Column If Usedrange of Column ISBLANK Follow-up | Excel Discussion (Misc queries) | |||
Hide Column If Usedrange of Column ISBLANK | Excel Discussion (Misc queries) | |||
Why is worksheet.usedrange empty? | Excel Worksheet Functions | |||
Excel 2007 BUG UsedRange/LastCell differences with Excel2003. | Excel Discussion (Misc queries) | |||
Real Value of .UsedRange.Rows.Count | Excel Worksheet Functions |