VBA Macro - Alteration of current macro to ignore hidden cells :)

**Defratos** · 01-14-2013, 02:20 AM

Hi everyone.

I currently am using the code below, which extracts data from several excel sheets into one database.

Please Login or Register  to view this content.

Within this macro, i would like the line of code below to cause those cells which are hidden to show up as "0" if possible.

Please Login or Register  to view this content.

For example, if the data is only from "C23 to C28" then the rest will appear as 0 on the database .

**Defratos** · 01-14-2013, 06:26 AM

bump

**nilem** · 01-14-2013, 07:26 AM

maybe something like this

Please Login or Register  to view this content.

and Defratos, please change the title of your thread (remove "Help please") because "Unfortunately your post does not comply with Rule 1 of our Forum RULES..."

**Defratos** · 01-14-2013, 07:45 AM

Thanks nilem, you saved me again

.

VBA Macro - Alteration of current macro to ignore hidden cells :)

LinkBack

Thread Tools

Rate This Thread

Display

VBA Macro - Alteration of current macro to ignore hidden cells :)

Re: Help please! VBA Macro - Alteration of current macro to ignore hidden cells :)

Re: Help please! VBA Macro - Alteration of current macro to ignore hidden cells :)

Re: VBA Macro - Alteration of current macro to ignore hidden cells :)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions