Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error in Range Statement
Does anyone know why this gives an error?
Worksheets(strWrkSht).Range(Cells(2, 2), Cells(intCopyTo, intCopyTo1)).Select -- M. Shipp |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error in Range Statement
Works fine for me (XL2k). Would suggest either a Debug.Print or MsgBox
statement for each variable before this line to verify that each variable does indeed have the expected value. Ed "SHIPP" wrote in message ... Does anyone know why this gives an error? Worksheets(strWrkSht).Range(Cells(2, 2), Cells(intCopyTo, intCopyTo1)).Select -- M. Shipp |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error in Range Statement
What error does it give?
What values are in strWrkSht, intCopyTo, intCopyTo1? Does that worksheet exist? -- HTH RP (remove nothere from the email address if mailing direct) "SHIPP" wrote in message ... Does anyone know why this gives an error? Worksheets(strWrkSht).Range(Cells(2, 2), Cells(intCopyTo, intCopyTo1)).Select -- M. Shipp |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error in Range Statement
You may have missed one reply at your first post:
http://groups.google.co.uk/groups?th...apeXSPAM.c om SHIPP wrote: Does anyone know why this gives an error? Worksheets(strWrkSht).Range(Cells(2, 2), Cells(intCopyTo, intCopyTo1)).Select -- M. Shipp -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function Error IF Statement | Excel Worksheet Functions | |||
If Statement Error | Excel Discussion (Misc queries) | |||
Can't fix On Error statement | Excel Discussion (Misc queries) | |||
IF statement error | Excel Discussion (Misc queries) | |||
On Error Statement | Excel Programming |