n.value

Hi all, Hopefully someone can put me out of my misery, as I've hit a brick wall with this one! So here's the plan: Sheet1: Contains all the data, pasted in on a monthly basis Sheet2 (Mapping Table): Contains the words which I'll be using in my autofilters In future the names used in the...

Hi guys, This is the macro that i create to insert a new number. Note that I have more than one sheets in my workboooks. In each sheets, there is a column called line reference. The line reference is defined as for exemple A050 or A001. It goes from A to F. For exemple we have A01 sheets, A02...

folks, some of my files are attaching and some are not. the macro below runs down a list and for every "Yes" in column F, create an email, and then add attachments. There could be 6 attachments at most per email. However, not every email will have all the attachments. The names of each of the...

I have received 2 macros from other users to check a 4th column against the first 3 in excel for duplicates. While they do run they are not working. My spreadsheet has the 4 columns and the data starts in the second row. Can anyone please advise. Sub ClearDups() Application.ScreenUpdating =...

Hi, I am just started to learn VBA and messing codes around. I got this runtime error with my codes. Here's how it sets up. A1 to A100 are ID number 1 to 100. B1 to B100 are "values" which all starts at 100. D1 to D100 are randomly generated number working as ID pointer indicating value flow...