Macro adds number to entire selection, how to avoid adding to blank cells?

**Butcher1** · 02-26-2014, 01:00 PM

I have recorded the below macro which will copy a value and the paste special and add it to the selection. The problem is that it is adding the value to blank cells when I do not want it to. Can this code be modified so that it doesn't add to blank cells. In the paste special dialog box I clicked skip blanks but this didn't change anything.

Please Login or Register  to view this content.

**Bernie Deitrick** · 02-26-2014, 03:05 PM

Change

Please Login or Register  to view this content.

to this, if the cells have values and not formulas

Please Login or Register  to view this content.

or this, if the cells have formulas

Please Login or Register  to view this content.

and if they are all values, you don't need to use all that selecting (though this is just a guess as to which sheet is active when the code is run)

Please Login or Register  to view this content.

Macro adds number to entire selection, how to avoid adding to blank cells?

LinkBack

Thread Tools

Rate This Thread

Display

Macro adds number to entire selection, how to avoid adding to blank cells?

Re: Macro adds number to entire selection, how to avoid adding to blank cells?

Thread Information

Users Browsing this Thread

Similar Threads

Macro to search column for blank cells & shift entire row right

[SOLVED] Macro that searches a column for all the blank cells then highlights the row entire row.

how can avoid considering of blank cells in IF function

[SOLVED] Looping Macro That adds a blank row between different part #'s

[SOLVED] Number of different items in an entire column without knowing if some of the cells are blank

Bookmarks

Bookmarks

Posting Permissions