How to shorten the code?

**joyce_88** · 10-28-2008, 10:31 PM

Hi,

Recently,I want to take the check the data in xlsheet_l is it the same data as xlsheet, some of the data will be transfered to xlsheet_l. I was able to run the few lines of code well. However, when I procedured to write similar code. I was unable to run my code as it encountered this pop up which stated that "out of procedure" . I feel that maybe my code is too long as result it comes with this " out of procedure" Is there any way to shorten my code?

Please Login or Register  to view this content.

**rylo** · 10-28-2008, 11:33 PM

Hi

In your lm_c6 loop, you suddenly have the variable lm_c3 as part of your cell definition in the Union. Is this correct? If not, then correct and see if you still have the same error.

rylo

**shg** · 10-29-2008, 12:26 AM

I've edited your post to add Code Tags. Please read the Forum Rules before posting again.

**joyce_88** · 10-29-2008, 09:36 AM

Thanks.I have change the code which you mentioned. However, the same error come out. what could be problem?

**shg** · 10-29-2008, 09:42 AM

Code has to appear in a procedure (a sub or function), e.g.,

Please Login or Register  to view this content.

**joyce_88** · 10-29-2008, 10:04 AM

Thanks.I have tried using function or sub before in the code. However, it didn't work. Is it because I have too many looping which result in this out of procedure?

**rylo** · 10-29-2008, 06:26 PM

Hi

See if this works. If I understand your code, the data from sheet1 will be moved to sheet2. This is running on my machine.

If this doesn't match your setup, can you please put up an example file showing what data should be moved where....

rylo

**Tirren** · 10-29-2008, 06:37 PM

Code always has to be surrounded by the sub/end sub or fuction markers to mask them, otherwise it is out of the coding box and can't be read.

Also, does it highlight any specific line when you click on debug?

How to shorten the code?

LinkBack

Thread Tools

Rate This Thread

Display

How to shorten the code?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions