Replies

Just to confuse things a little further, in your example, I can click on cell n7, press enter to drop to cell n8, press enter again and not get an error message. Also if I click on cell n8 and add an additional “x” so it reads “xx” and press enter it will give the error message, then if you click cancel then enter you can drop to cell n9 even though it is still an error.
These little boxes we play with every day are just filled with magic, aren’t they!!
Stats

Thank you very much Macropod, it worked great. FYI because our parts are alpha numeric instead of numeric as in your example, I used COUNTA instead of COUNT in col A of Sheet 2.
If I may throw a small curve ball at you, how would I get the sub parts to display across the columns instead of down the rows.
So col A would have the part, col B would have the first sub part, c would have the second sub part etc.
Thanks again for your help.
Stats

Good Morning Legare,
No, all of the minor parts appear in their own cell. MS Query returns them roughly as follows:
A B
1 FGABC1.0 BTTOR1.0
2 FGABC1.0 CPWHFC
3 FGABC1.0 BXABC1.0
4 FGBBO500 BTTOR500
5 FGBBO500 CPWHFC
6 FGBBO500 TRGEN500

There are over 500 different parent parts that appear in col A.
Thanks
Stats

Good Day Hans,
Thanks again for your help with the macro, but there is one unforeseen problem. Is there a way to undo the inserting of the rows when I close the workbook so when I open it the next time it’s inserting the rows in the correct spots again.
Thanks,
Stats

Thank you Hans, it worked exactly as I needed it too.
Stats

Thanks for your reply John. No, I am not deleting the rows after putting them in. It’s a report that pulls some information from our SQL Database using MS Query and outputs a report of what products have to be produced in the near future. Each part can appear on the report one time or it can appear a dozen times depnding on how many orders are outstanding but it is sorted by the part number in Col. D. Inserting the blank row between each part makes it easier to look at.
When I ran your code I got an “Application-defined or object-defined error”. The sheet in the workbook is called “Sheet1” and I couldn’t find any other “variables” I would have to change in the code. Have I missed something.

Thanks again Stuart, it never ceases to amaze me how helpful people are at Woody’s Lounge.
Almost all of the computers here are ’98 but there are a couple of Windows 2000, is the whole process any different for them?
Stats

Worked like a charm, thank you very much. One question, when it updates the time a DOS message window comes up letting me know it was successful, is there a way to atoumatically close this window?
Stats

I’m not sure what you are using the cell for, so this may not work but if you type the 1-10 with a single quotation mark preceding it….. ‘1-10 then it will display as 1-10.
HTH
Stats

Thank You very much John!!
It works great, I don’t need blank or empty cells hidden, it was just the gaping holes in the report I needed cleaned up and this works fine.
Thanks again for taking the time to help.
Stats

Thanks for your quick reply.
I’m sorry, I forgot to mention that the cells in Col D contain a formula that returns the value “” if some conditions aren’t met. These conditions determine if the data retrieved is supposed to be there. Since the cells are not “blank” the macro is not hiding them.
It worked perfectly on rows that had no data though.
Thanks for your help.

In your folder list click on the file that contains your contacts, go to “File”->”Folder”->”Properties for ‘whateveryourfileiscalled'”. Choose the “Outlook Address Book” tab and check the box that says “Show this folder as an e-mail Address Book “. In the “Name of the address book” type in the name that you want to appear.
When you click the “To:” button at the top it will say “Show names from the:” select “Contacts” or whatever you named it as.

Good Luck,

I’m not 100% sure but I believe that the paragraph style can only be applied to email in the HTML format. To change the format back to “normal” click on “Tools”->”Options”->”Mail Format” and beside the option “Send in this message format” select anything other than “HTML”.
Hope this helps.
Stats

Ooops, sorry about that, I missed the part where you wanted a 0 to read “N/A” as well.

Try =IF(ISERR(A6/A7*100),”N/A”,IF(A6/A7=0,”N/A”,A6/A7*100))

(Don’t forget to delete the “*100” part if col B is formatted as a percentage.)

Stats

Try =IF(ISERR(A2/A3),”N/A”,A2/A3*100)

or =IF(ISERR(A2/A3,”N/A”,A2/A3) if column B is formatted as a percentage.

Good Luck,
Stats