View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 11
Default SubScript Out Of Range.

Last week some nice folks here gave me a few tips, and I was able to get
the macro I had been working on to run properly. Thanks!

But today, I ran the same macro on a worksheet that was laid out exactly
like the earlier one, and I got `Subscript Out Of Range.' error. I made no
chages to the code.

Here is the line that program stopped at:

FullName = Worksheets("Sheet1").Cells(I, 4).Value

I thought maybe the error was caused because the macro was not actually
in the workbook I was using. I copied it to that workbook, but same thing
happened.

Anybody have any idea??

Sam

A man who had lately declared
That property ought to be shared,
Thought it going too far
When they called for his car,
And a list of exceptions prepared.

Thomas Thorneley,
From The Penguin
Book Of Limericks