Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help with selecting a range
Hi,
I have this code; Sub dump() Sheets("raw1").Select Range("car1").Select Selection.Copy Sheets("car1").Select Range("a1").Select Selection.Paste End Sub All I am looking to do is to select a named range and copy and paste to another sheet. However on the Range("car1").Select line i get an error; Run time error 1004, Application defined or object defined error I originally thought this would be a problem with the name of the range, but I have tried naming a single cell as a range "pink" for example! and it still doesn't work. Any clues? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting the correct number from a range of cells | Excel Worksheet Functions | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Range selecting cells | Excel Discussion (Misc queries) | |||
Selecting a Range | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |