LinkBack URL
About LinkBacks
How to:
1. Find column with header title "quantity" (column with text "quantity" in row 1)
2. Clear all data below the header for that column only (rows 2 - lastrow)
How to:
1. Find column with header title "quantity" (column with text "quantity" in row 1)
2. Clear all data below the header for that column only (rows 2 - lastrow)
Last edited by ks100; 01-02-2014 at 04:06 PM.
try this code :
Please Login or Register to view this content.
Happy Computing ,
Xlbiznes.
To show your appreciation please click *
Maybe:
Please Login or Register to view this content.
Excellent, I knew I was missing something simple.
I'm starting to get the hang of how the offset command works (after throwing the machine into a few endless loops that crashed Excel). Thanks for all the help everyone.
Last edited by ks100; 01-02-2014 at 04:11 PM.
Hello ks100,
If you are interested, here is an easier method...
Please Login or Register to view this content.
Last edited by Leith Ross; 01-02-2014 at 05:03 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!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks