make VBA code smaller

**roberto1111** · 10-14-2009, 12:23 PM

Hello friends,

I'm a beginner with VBA and I want to ask if someone can provide me with the VBA code to make this long code as small as possible.

Thank you in advance for any help offered.

Please Login or Register  to view this content.

**shg** · 10-14-2009, 12:31 PM

Maybe like this:

Please Login or Register  to view this content.

**roberto1111** · 10-14-2009, 12:40 PM

Shg, thank you for your reply.

How do I let the VBA code skip one column if it's empty and it doesn't need to be calculated?

Greetings

**shg** · 10-14-2009, 01:18 PM

Use two lines of code.

**roberto1111** · 10-14-2009, 01:29 PM

I mean something like;

If ActiveCell = "" then next ...

**shg** · 10-14-2009, 01:30 PM

No, like

Please Login or Register  to view this content.

**roberto1111** · 10-14-2009, 02:52 PM

It did not work so to make my query more clear I've attached an excel file.

make VBA code smaller

LinkBack

Thread Tools

Rate This Thread

Display

make VBA code smaller

Re: make VBA code smaller

Re: make VBA code smaller

Re: make VBA code smaller

Re: make VBA code smaller

Re: make VBA code smaller

Re: make VBA code smaller

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions