| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range selection not working
hi
Iam using officeXP and the following VBA code is not working in EXCEL. I would greatly appreciate if somebod can tell me the correct way to do this code. I get 'select method of range class failed" error message ' here is the cod dim cvalue as intege cvalue= Worksheets("sheet2").Selec Range(Cells(cvalue, 1), Cells(cvalue, 54)).Selec Selection.Cop Sheets("Sheet3").Selec Rows("2:2").Selec ActiveSheet.Past ' end of cod thank Kana Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Narrow Range based on Selection in Another Range | Excel Discussion (Misc queries) | |||
| Identifying a selection of a selection of a range | Excel Worksheet Functions | |||
| Ctrl-Space Column Selection No Longer Working | Excel Discussion (Misc queries) | |||
| Selection.count isnt working | Excel Programming | |||
| Creating range name for a range selection | Excel Programming | |||
Threaded Mode
