Expanding on existing VBA code

**gss** · 09-13-2010, 01:30 PM

I have the following code:

Please Login or Register  to view this content.

What I would like for it to do is to continue to execute the above function if O_1 > 0 or O_1 < 0, but if O_1 = 0, then to ignore the code. So in effect, if O_1 = 0, exit the function without assigning a value to SectionBottom.

Any advice?

Thanks.

**Cheeky Charlie** · 09-13-2010, 02:19 PM

Please Login or Register  to view this content.

Code's easier to read (hence debug) if you break out your ifs into blocks, so I'd actually recommend:

Please Login or Register  to view this content.

I'd also indent it, but I can't do that without easily using the VBE and without any context I can't really test what I'm telling you

HTH

Expanding on existing VBA code

LinkBack

Thread Tools

Rate This Thread

Display

Expanding on existing VBA code

Re: Expanding on existing VBA code

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions