macro loop

Hi, I am trying to build a macro that will add multiple columns into 1 column and remove duplicates. I ran across an issue where if a column is blank i was getting an error so i was trying to build a loop where if it is an empty cell to delete that column and move to the next step. I am...

Hi again all, I'm think I made my first post too wordy and overly complicated things..... I have a column of URLs in column A of "Sheet1". I have a web Query on "Sheet2". I want a macro to loop through all URLs in column A of "Sheet1", changing the WebQuery to use the URL as it's connection...

Hello Mr. Excel world! Long time reader first time account maker/poster. I have a workbook with a number of different Worksheets. I have a column (Column M) on a worksheet called "AM INTL" Briefing. This column contains a hyperlink on each row (none are blank right now, but there could be...

Hi, I have the following macro which I'm using to find a value that is in my ControlSheet in cell B11, in column M of the Datasheet, and then it deletes the row. It also copies the row to the RecordsRemoved tab before completing the macro. My requirements have changed and now i need this...

if you look at the table below, there is a date column and a name column. in a perfect world, i want to copy a list of names to my clipboard and run this macro. the macro will paste the contents to sheet1, convert as many names as i paste to a table, then on sheet 2, create these two columns for...

OK, for some reason (someone probably knows why) when I use the macro below to add a hyperlink to all cells in one column of a table the loop will reach a value that is just numbers and spit out an error. the values in the cells are the names of other worksheets in the file. and the values are...

Hello everyone, I am a begginer in VBA and had no real training so I am learning on my own by reading books and exploring forums. I went through many posts in several forum and Microsoft websites in order to write the code I need but unsuccessfully. What I am trying to do: If the cells in...