Hi I think I only need to replace a line of code in the following to detect if any of the Cells in a selected Range are not blank. i have code to detect Merged Cells but not for single cells.
Hope someone can help
Many thanks
Hans
I'm still learning !
Please Login or Register to view this content.
Try this in your original code. CountA is a worksheet function that counts cells that are not blank.
Please Login or Register to view this content.
Or here's the whole procedure cleaned up a bit.
Please Login or Register to view this content.
Last edited by AlphaFrog; 04-07-2018 at 06:11 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Try
Kind regardsPlease Login or Register to view this content.
Leo
Many thanks - That's just what I needed !
I'm still learning and every response I get from this forum has been just right !!!
Marked as solved !
Hans
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks