vba

  1. M

    Application.Evaluate use R1C1 reference instead A1 Reference

    How can I use R1C1 references instead of A1 references. This is an example of where both collides and A1 references is used instead: Evaluate("=C1") (I want to get the first column values).
  2. Y

    Data Update using VBA

    Hello Everyone! I have two files named Purchase Requistion (PR) and Database (DB). PR is in the format of a form which they fill in order to raise a PR request. This file is then "Save As" with a different name so as not to disturb the native file "PR". DB is a table format, which takes the...
  3. C

    Extracting Specific Fields from multiple PDFs with VBA (Excel 2019)

    Hi All, I been given a folder with a list of PDFs and I need to extract certain fields out of it to an excel sheet. However, we are only capable of using Excel 2019, so Power Query was out of the window. I'm currently attempting VBA to solve this problem. However, I'm not well-versed at all...
  4. H

    How to copy data from one file and paste it into a dynamically named workbook

    I am currently creating a macro to improve a weekly file update process. I have to copy a specific range of data from one file (file name "Previous Weeks File") and paste it into my current week file - the new week's file name has date changes: "File Update - 03-17 (Weekly)". How can I copy the...
  5. M

    Access data from a closed workbook

    Hi all! I have a report that is generated weekly for example 2401, 2402, 2403 etc. Is there a way that i can access data of these workbook from a master sheet. I have a formula that basically concatenates to the sheet name eg P:\weekly exports\2404.xlsm Is there a formula or vba that lets me...
  6. R

    Trying to write VBA script for the choosecols and filter function in Excel

    Hello, I’m trying to write a vba script to return all columns that match a list of numbers. Some numbers have multiple rows of data. I use the choosecols and filter function to return the data which works. Now I’m trying to write a VBA script that does the same thing. Problem now is that it’s...
  7. R

    VBA Code for pasting Value every nth cell in 2 different rows

    Hi there, I'm a bit stuck on some VBA code and need some help! I want to create some code for a macro button that will auto populate a value from cell A1 in cells Q19 and AJ19 and carry on doing this every 14 cells in both columns. It would be great if the VBA loop ends at row 355 as this is...
  8. M

    Cut/paste last 36 rows and move to a new worksheet

    Hello - newbie here. Using VBA, I need to cut the last 36 rows of data and paste them to a new sheet. The actual number of rows will vary each time we use the sheet. Any help would be greatly appreciated!
  9. E

    VBA -highlighting rows when a condition is met

    Morning I have a code that highlights rows when in column B the word red is inputted, however, I need the code to work when I press enter is that possible Sub HighlightRowsWithRedInColumnB() Dim ws As Worksheet Dim lastRow As Long Dim i As Long ' Set the active sheet...
  10. R

    VBA Script for copying a range of cells from multiple worksheets into one worksheet?

    Hi all! Knocking out a huge project for work and I'm looking for anything to save time. I have successfully imported ~100 workbooks into a single workbook as sheets, labeled "3" to "103". From each of those ~100 sheets I'd like to copy the data in cells A11:Ax, C11:Cx, E11:Ex, and I11:Ix (from...
  11. D

    vba code to refresh a connection only query

    Hi am am trying to see if there is vba code to refresh a query that is a "Connection Only" i have the below code i am using but i am not seeing the query refresh when i go step by step in the code Sub RefreshSpecificQueries() Dim queryList As Variant Dim i As Integer Dim conn As...
  12. K

    VBA change the font of the first letter only in each cell in a range to a specific font

    I'm trying to use the following code to change the font of the first letter only in each cell in a range to a specific font (which is a pie chart font) so that it appears a pie chart and then a value: Sub Set_Pie_first_char() Dim r As Range With Range("e27:i27") For Each r In .Cells...
  13. Agnarr

    Checkbox Timestamp with VBA

    Hello everyone! I have a huge problem. we utilize a "to-do" list with checkboxes that are inserted into each new sheet with the following code: Sub InsertCheckBox() Dim rng As Range Dim chkBox As CheckBox Dim cell As Range Dim i As Integer ' Set the range where you want...
  14. N

    Pasting Value with VBA - Sorta Looping based on a multiple of 30

    I want to create a VBA code that pastes different columns within a row to a pdf, then move to the next row and do this to 30 different rows. Then I want it to save the document then continue from where it left off. Therefore, after 30 rows have had their columns pasted into the text boxes within...
  15. K

    Text format for numbers to preserve trailing zeros

    Hi All, I am a newcomer here. I found an old question which I am interested to. https://www.mrexcel.com/board/threads/text-format-for-numbers-to-preserve-trailing-zeros.811427/ I ask anybody to write a Sub file to apply this Function published there...
  16. K

    VBA deleterows

    Hi, I just wanted to ask how can I retain the rows if column F or StartString(Font in red) starts with number. Below is my code. Sub DeleteRowsraw() Dim c As Range, DeleteRange As Range, DataRange As Range Dim LR As Long Dim i As Long Dim StartString As String 'change...
  17. W

    Excel VBA/Macro Help

    Hi Everyone, I have an online appointment scheduler, using "https://www.squarespace.com/acuityscheduling". So far I have been manually copying all of the client information manually. Below is the information I gather manually from the website and put in my excel sheet. Is there a way I can...
  18. G

    Still no solution after 1 Year - Please Help

    So the short version is: I have a tool that makes signs for items. The paper it prints on is divided into 8 signs. (8.5x11 Sheet) I have tried every different option to get it to print properly and I cannot. Each page should have 8 signs. I keep getting overlap or width issues. ("A1:BM99")...
  19. D

    Create empty table (with headings) in Word document after some text

    Hi guys, I hope this is the right forum for this question. I'm fairly competent in VBA in Excel, but recently started tinkering with creating letters in MS Word from our Excel VBA programmed management system. I work in Microsoft 365. I'm creating a Word document from scratch (out of Excel)...
  20. M

    Find Function VBA Named Argument Not Found-Runtime error 448

    I am writing a macro( late binding) that runs through a word document and highlight all the values that is contained in my cell range in Excel. I have used the find function which works fine until I add the argument IgnoreSpace:= True, which I don't understand why it's resulting in error...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top