Posted to microsoft.public.excel.programming

SHIPP

external usenet poster

Posts: 29

Error on select statement

I am working in Excel 97 and am getting a 1004 error - Application defined or
object defined error. The code is

Worksheets(strWrkSht).Range(Cells(2, 2), Cells(intCopyTo1,
intCopyTo)).Select

I have stepped through the code to determine the value of the variables:

intCopyTo1=211
intCopyTo = 6
strWrkSht=Master

All variables are accurate. Any help would be appreciated.
--
M. Shipp

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select Case Statement	Katie	Excel Worksheet Functions	13	December 1st 08 07:32 PM
If Statement to select a letter	Karl	Excel Worksheet Functions	3	February 8th 08 04:01 PM
SELECT statement	Tom Ogilvy	Excel Programming	2	July 23rd 04 06:24 PM
SQL Select statement with Date as	Pepe[_2_]	Excel Programming	3	February 4th 04 06:50 PM
Adding SQL Select Statement	Pepe[_2_]	Excel Programming	1	January 29th 04 02:19 AM

All times are GMT +1. The time now is 02:00 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us