I am using the following code:
The part of my code that bolds k4:k100 I need to edit so that the total row in K is not bold. Just the data. The trick is that the total row moves around each time I use the sheet. So, if the macro could locate the word "total" in my merged columns "AB" and then unbold the corresponding cell in "K" it would be perfect. I have no idea how to edit the code.
Please Login or Register to view this content.
Thank you for your time and help.
I do not understand what you mean by
I need to edit so that the total row in K is not bold. Just the data
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
Merged Cells will generally cause problems when coding, try to avoid them by using Centre across selection from the Format Cells menu.
Also, it is not necessary to Select or Activate cells.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
FYI
I added this to my macro and was able to solve my problem.
Thanks.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks