Reply to thread

Message

[QUOTE="Rob, post: 6276809"]
Hi Gretchen,

Where's the full procedure? What worksheets does it use? What's in these
sheets? What does it have to do.

No-one here can make soup of your question, I think. But I want to help you
another way wit a few tips.

-    First: break up your code in little pieces/procedures. Name those
pieces with names you recognize.

-    Use logic names for you variables, like usein intRow instead of r (int
is for knowing there's in integer in it, Row for knowing it's for storing a
rownumber.)

-    Test your procedure in parts. Say you have broken down your full
procedure into 4 subparts. Do this:

Sub DoEverything
'    Start with this procedure and test only the first part.
'    If it works, remove the ' before the second part, and run this
procedure again
Call Part1
'    Call Part2
'    Call Part3
'    Call Part4
'    BTW, I alway use Call the know I call for another procedure

End if

Sub Part1
'    Here's something happening
End sub

Sub Part2
'    Here's something else happening
End sub

etc.

This way you are likely to find the problem yourself.

Rob
[/QUOTE]

Verification