Quote:
Originally Posted by Logit
.
This should work for you. The macro is pasted in ThisWorkbook module so it affects all
sheets in the workbook. If you want it for only one sheet, you can move the macro into
that sheets module:
|
Hey Logit, thanks a lot. That is the BCEFI (best code ever found in Internet) :0) It really worked for me and will work for the world. God bless you. I really appreciated that. This one doesn't mess any format (border, fill, fonts, anything) and better, it marks lines when you select a range. AMAZING! I have no words to say thank you for you help.
Just as a comment and if you want to burn your mind in programming a little more, just two issues found in this code:
1. See attachment, when freezing panes it mess the selection. Just creates the line on the visible area. It would be great if it was possible to make the row line in the whole line of the spreadsheet like when we do SHIFT+SPACE;
2. Not sure if it is possible, is to make the "Green" line to be on the back (behind) the selected cell, because the way it is now, it isn't possible to select/pick the fill handle (+) on the corner of the cell to do commands like repeat values by dragging or the increment values. Not big deal because there is a workaround by selecting the "green" line, moving it to the side and going back to the cell to click on the handle (+). But if it was possible to make the lines behind, the workaround wouldn't be necessary.
Anyway, it works amazing. Thanks, thanks, thanks.
Have a stunning Sunday.