LinkBack URL
About LinkBacks
I need a code to do the following:
1. Search in row 1 until it finds the header text "Balance"
2. Check every cell in that column until the last used row of the spreadsheet is reached.
For every cell:
Please Login or Register to view this content.
I need a code to do the following:
1. Search in row 1 until it finds the header text "Balance"
2. Check every cell in that column until the last used row of the spreadsheet is reached.
For every cell:
Please Login or Register to view this content.
Last edited by ks100; 02-21-2014 at 09:25 AM.
Hello ks100,
This macro worked for me...
Please Login or Register to view this content.
Last edited by Leith Ross; 02-20-2014 at 06:53 PM.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Try this to replace all BLANK cells in column with header title "Balance" to "0" :
Please Login or Register to view this content.
Works great, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks