#loop

Hello, I'm trying to automate a Boolean process on Excel and was hoping to get some help with the loop/vba logic. Column A contains integers that range between 1-4. I would like to create 4 columns on the side (since "A" contains 4 possible values) which have the following logic: If...

Hi All I am looking to print/save multiple PDF documents on one sheet however I need one variable to change before it saves/prints to PDF. Currently I have the following macro which "works" however it requires me to type in a file name, choose a file path and then click save on each and every...

Hi, I created the below macro with the goal of updating in bulk (find/replace) some of the data inside multiple xml files saved in a folder. However, the below macro is only updating the first file saved in the folder and requires debugging on this line "Open sFileName For Input As iFileNum"...

Hi guys, i would like to identify one row on a table with multiple merged cells in multiple column. Imagine something like this: ABCDEFGHIJK1Col ACol BCol CCol DCol ECol FCol GCol HCol ICol JCol K23456789101112131415161718192021 to identify the row the data has to be the same in (for exapmple)...

Hi, this may sound easy but i'm new to vba so i don't know the exact syntax to use... I want to loop throught all Textbox in a userform and wanna perfom a specific command if they are empty or not... the boxes are all named TextBox1, TextBox2, ... so I wanna have acces to the value in it and...

Hi there, I don't seem to find a solution for this challenge. Below is a dummy data for demonstration purposes only (data highlighted in blue represents cells being selected by a user): > columns: A D H Row 8 2 10 5 Row 18 7 44 3 Row 27 9 66 User is...

Hi, a run time error 1004 occurs whenever the macro has finished looping through sheet names which contains "Country Financials". Your help please on what workaround should I do to prevent the error and continue to save the workbook. Thank you in advance for your help! Sub FormatFiles() Dim ws...