rcount

Hi all, Apologies, I've been doing some reading and little out of my depth. I'm trying to convert the below code to work with worksheet_deactivate() command (when leaving a worksheet "Rebate Conditions"), however not having any luck. It works as a macro in a button on the sheet, just not when...

Hey, I've got a piece of code that copies all selected emails from Outlook into a specific Excel Document, all working fine. I've been trying for sometime now to add a progress bar to this so i can see where it's up to as this can sometimes take in excess of 30 minutes to complete and outlook...

Hi, I have the below code extracting emails from outlook into excel. When i step through the code the string is being returned with the correct date format however, when its put into Excel it has been changed to US date... any suggestions? I have checked my language settings and they are all...

Hi Again, Finding this forum really useful and some great people on here, learnt alot over the last few days. Looking for some help again, Below is some code that extracts emails from Outlook and puts them into cells in Excel. Hoping someone can tidy up the code to make it run faster and also...

Hi, I need some help with the below - I have a spreadsheet which contains a filter and "rng=.SpecialCells(xlCellTypeVisible)". For example, it will always copy from range A17 to G25". I wish for it to start from B17 and end at the last G cell of the filter. Can anyone enlighten me on how to...

Hello Mr. Excel Forum members, I need you help and advice. The code below works fine but I wanted to get away from hard coding the column / row numbers and use the Table header names instead. Any help would be greatly appreciated. -Don If rNumber_of_Rows = Number_of_Rows Then...