sheet observation , columns D and E ,H , V find last cells used then clear any format and contents of the last cell IN VBA
sheet observation , columns D and E ,H , V find last cells used then clear any format and contents of the last cell IN VBA
Please Login or Register to view this content.
Last edited by buran; 06-29-2017 at 07:06 AM.
If you are pleased with a member's answer then use the Star icon to rate it.
Perhaps...Using buran's code....
Edited...OrPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by sintek; 06-28-2017 at 12:47 PM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Buran & Sintek
Thank you , an insight how to remove the cell borders linestyle from the last cell with the above code
Pleasure glad I could help...thanks for rep...
an insight how to remove the cell borders linestyle from the last cell with the above codePlease Login or Register to view this content.
of course, there should be no brackets:
sorry for he mistake and thanks for repPlease Login or Register to view this content.
@ buran
Perhaps
.Range(cols(c) & Rows.Count).End(xlUp).ClearContents
Please Login or Register to view this content.
Yes, right. I have to stop for a moment and go for a coffee break :-)
Last edited by buran; 06-29-2017 at 07:39 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks