excel vba

HI, I am a rookie VBA coder, I use it to automate work for myself :-) I have this piece of code that is part of a larger routine, all works but I would like to make some text bold and underlined and some normal. With wdDoc.Content '--- paste the range image first, because it...

good afternoon all, I've been tasked to contact over 500 companies my work deals with on a regular basis and need updated details from, I have collated an email sheet and have used the following code to produce the emails to each company, as I didn't want to fill out an additional column on...

Hi, in order to speed up my attached code, I would like to loop (for - next) only the last 200 rows instead to loop all the ranges AA:AA and L:L. How could I do that? Please, note that the data from Production data.xlsm is increasing every day and the code selects the ranges with an "X" in...

Hello I need some help with the code below, Sometimes the page does not login, sometimes the iframe does not load, I am looking for a way to handle this error and attempt again and not resume, if not then exit and login in again. In bold are the areas where sometimes it crashes. Any help or...

Hello, I use the following code to make a new file after deleting the certain columns from the old file, but I want to add one more thing here, if any of the three sheets ('Sponsored Products Campaigns', 'Sponsored Brands Campaigns' ,'Sponsored Display Campaigns') are empty (i.e. A2 is empty)...

Happy Friday, On a spreadsheet, using a filter in a header row manually Top rows, including header are frozen After selecting an item from the filter list and clicking OK, Excel does not select the cell to which it just filtered How do I get XL to select the cell to which it just filtered...

Hi all, I am working on a project that uses a form I have created in Excel to populate Rich Text Formats in a word document in order to streamline report generations. I have almost completed the project but I have ran into a problem I can't seem to figure out. I am fairly new to the VBA...

I have a small section of VBA code (as part of a larger macro) which takes some of the pages of the report I'm working on and saves them to a new file. Dim wb As Workbook Set wb = Workbooks.Add ThisWorkbook.Worksheets(Array("Page 1", "Page 3", "Page 4", "Page 6", "Page 7")).Copy...

good day, I am a very basic user and am trying to find a code to only send to a single email address (located in R1) using outlook based on all data in a spread sheet to let a supervisor know before someone returns. I would like this to be sent out -7 days prior to "End Date" in (column J). I...

In A1 I have a letter character, e.g. "H" In A2 I have a formula Need VBA to replace multiple characters in A2 string, by their position number, with A1 value Positions, counting spaces, are: 3 15 39 And another version, to replace by placeholder characters, i.e. if characters in A2 needing...

Hi All, I recorded a macro to see if there was a way after I inserted 3 slicers, to select report connections for each of the slicers to select pivot table without having to right click and select report connections for each slicer. This is the below macro code from the recorder: Sub...

Hello all, working on a code that needs to be able to search a specific range Sheet1.Range("N15:EM134") Once found process the below actions: Align text to the right of the cell Increase the font size of the found text to size 15 Alternatively, I would need to do the same thing in the same...

Trying to have VBA fill in a formula in the range, but getting below error... Sub GFormula() Range("G10:G27").Formula = "=IF(B10="","",IF(OR(B10="LABOR - CU",B10="TRVL - CU"),"HOURS","EACH"))" End Sub

I have a little issue with my code. The purpose is to get a specific range of data from each file (F19:F42), and to copy that range to another file's gathering sheet named "Extraction" piece below the previous piece, and form a column with 720/744 rows of data, depending the month. The issue is...

Good After Noon, Trust everyone is Good Preparing a small tool which helps me in Daily routine at my work. I have a data where i am creating a pivot table and need to report out the numbers to my Team where we stand. I have written a code so far where pivot table is getting populated with the...

Hi All, I am working on my SAP automation process. I have written most of it but I am struggling with writing code for copying dates from two different rows to Posting date : "from" and "to". LastRow = sht.Range("D2").CurrentRegion.Rows.Count sht.Range("D2").Copy...

Hi, I have an excel document with a list of projects and need to do notes for each project. I want to open a worksheet for each project and for the new added projects with a VBA code. The new worksheet needs be be labeled with the name of the project/s There also need to be a lay-out on these...

Hello everybody, I have recently started learning Excel VBA, with an eye of making a couple of apps for myself. However, I would now be interested to make them as .exe files and standalone projects, so that I might possibly be able to sell them. So far I realize that ; - Excel VBA needs ...

Hello, I have a code that returns unique rows from one sheet to another. I want to exclude specific columns from the range from B5:P1048576 and show them in Sheets("Item-Wise Summary").Range("A5:O5") Sub RemoveDuplicates() Dim rngDatabase As Range 'define the database Set rngDatabase =...

2 OptionButtons if value is false on both of them then show error message after that let user go back to select optionbuttons again or start all over again How I can do that? I spent many hours for this but not success. Thank you very much.