Search results for query: *

thanks Glen, Yes i thought of that but i just have some space requirements...Would there be any way i could have a hidden column and have a macro(VB) that runs when a filter arrow is pressed, so it inserts the line??thanks eoin

I have a problem in relation to filters in excel. I have a list of about 2000 rows, with the rows being divided into four sections. I want to filter all columns. When i use 'Autofilter' in excel it removes the rows which give the section name once a value has been selected. So in other words...

Thanks a million PHV and everyone else...That worked perfectly i was trying to do a hidden field with a forumla but that worked so much easier!

Thanks bdmangum, Jsut got an error 1004, stating that "Excel cannot shift non blank cells off the work sheet". Think i know how to fix it.. I'll keep you updated.. Code .Cells(count, 1).EntireRow.Insert Shift:=xlDown

Hello, I am looking to write a macro that deletes certain rows on a sheet. I have just written a macro that inserts a row between entries for formatting purposes. However on some occasions there are two accounts listed with the same Account number. When this happens i want to keep the two...

Thanks for that Skipvought..The problem is with the rows i have just inserted but it has to be done because the people in Management are computer illiterate, and insist that a coloured rows are inserted between each entry, so its easier for them to read!

Hello, I looking to write a macro that deletes certain rows on a sheet. I have just written a macro that inserts a row between entries for formatting purposes. However on some occasions their is two accounts listed with the same Account number. When this happens i want to keep the two accounts...