Hi,
I have an excel sheet and I want to filter for BLANKS in multiple columns and provide comment of the other column. Can some one help me writing a macro/add-on? expand ยป Here each time the columns will not be the same, so it would be good if the macro asks for the range and perform the activity. And second criteria are next column if I specify the path is should populate with the value as "No" for the entire BLANKS and "Yes" for the non blanks one. Example file attached for reference, where in my range will be from open price i.e from column AG to AZ and in next column i.e BA I should have comment as "No" for BLANKS and "Yes" for NON BLANKS. Thanks and have a nice weekend...!!! Regards, Raj -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
