Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine specific range
Hi all,
I have the following code Dim MyBook as Workbook Dim SrcRange as Range Dim ShtName as Variant Dim N as Interger .... Code ... set SrcRange=Mybook.Workshhets(ShtName(N)).Range(Range ("A2"),Range("A2").SpecialCells(xlLastCell)) .... morwe code This gives me an Application or Object Defined Error. If I use the following it works well but I do not get the specific range I need. set SrcRange=Mybook.Workshhets(ShtName(N)).UsedRange Can someone pleasse help with this as it is driving me barmy Thanx in Advance/sgl |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to determine the value within specific cell position? | Excel Discussion (Misc queries) | |||
How to determine whether a list contains a specific value? | Excel Discussion (Misc queries) | |||
determine the active workbook containing a specific sheet | Excel Programming | |||
Determine which cells from a specific range equal a certain sum | Excel Worksheet Functions | |||
Determine shape name associated with a specific cell | Excel Discussion (Misc queries) |