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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range selection not working
Hi Kanan,
You are not mapping the source onto the same size target. The problem is in the Rows("2:2") So instead of Rows("2:2").Select you could use Range("A2").Select which will copy into A2 across -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "kanan" wrote in message ... hi, Iam using officeXP and the following VBA code is not working in EXCEL. I would greatly appreciate if somebody can tell me the correct way to do this code. I get 'select method of range class failed" error message. ' here is the code dim cvalue as integer cvalue=4 Worksheets("sheet2").Select Range(Cells(cvalue, 1), Cells(cvalue, 54)).Select Selection.Copy Sheets("Sheet3").Select Rows("2:2").Select ActiveSheet.Paste ' end of code thanks Kanan Any ideas? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range selection not working
Thank You Bob. That worked great
But I am still not sure why Rows("2:2") is not the same as Range("A2"). I guess my understanding of the Rows is not correct. can you please explain thank Kanan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range selection not working
Hi Kanan,
Rows("2:2") refers to the whole row, al 256 cells. You are copying 54 cells, and when you try to paste 54 onto 256, you get an error. But if you try and paste 54 onto 1 (which Range("A2") is, it copies across or down the requisite number of cells, as in the source. The same happens in Excel,. Select A1:J1 and copy. Then select row 5 and try and paste, you will get an error. Select A5 and paste, and you will see it paste all the way across to J5. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "kanan" wrote in message ... Thank You Bob. That worked great. But I am still not sure why Rows("2:2") is not the same as Range("A2"). I guess my understanding of the Rows is not correct. can you please explain? thanks Kanan |
Reply |
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 |