vba

  1. S

    VBA Help Goal Seek with dynamic cell

    Good day all! I'm trying to make a goal seek function but the change cell target is dynamic based on a certain cell. Hoping to have some help or improvements on the below. Thank you! Sub GoalSeek() Dim Answer As Integer Answer = MsgBox("Run values?", vbYesNo + vbQuestion) If Answer...
  2. S

    Vba - generate random alphanumeric strings based on user input

    Hi all. I am looking to create a VBA which generates alphanumeric values( numbers and caps letters) based on user input. For example if user says 15, 15 random alphanumeric values need to be populated with a max length of 35 in column A. Column B should populate 15 random alphanumeric values...
  3. J

    VBA to compare rows in two different sheets, if match highlight cell

    Hello. New to this board. I found some code that compares two worksheets (sheet 2 with sheet 1) to determine if there are any differences in the rows. The code works perfect for highlighting the entire row. If there is a difference in the row on sheet 2, it is highlighted in red. Instead of...
  4. C

    VBA-Photos to be imported from Sharepoint Site rather than local drive

    Hi all, Hoping someone can help me figure out a solution - ive checked a few posts and cant seem to get the right bits for what i need to figure this out myself I currently have this VBA code that works perfectly, however, if others are wanting to use this report, as they dont have access to...
  5. C

    VBA If Functions, blank cells, and message box

    I’m looking to add a message box to an existing if function. If i search something in a range, i have it highlight that result, so long as it returns it. If it doesn’t i would like to add a message box that pops up, like an error. Is this possible? The table range could possibly have some blank...
  6. T

    How do you compress all pictures in Excel with VBA?

    Our Excel files are stored on SharePoint Online and they are very picture-heavy. Some files reach 300MB and we need a way to reduce the file size. If I run the Save As command I can get to the tools menu to compress images and bring a 300MB file down to 100MB, but how do I do this with VBA? I...
  7. R

    Is there away I can but a button or something like that to change color on a Tab

    Is there away I can but a button or something like that to change color on a Tab
  8. Agnarr

    VBA problem with creating new sheets

    Hello everyone! I have made a sort of registry crm where one enters product code and quantity, excel returns name of product and price*quantity, plus it calculates start and end registry, loses, gains and other stuff. Some macros that clear specific cells and 2 more macros that: 1. user enters a...
  9. Chris_010101

    Simple VBA Code help

    Hello, My excel is a master document that pulls in data from different excel sheets in different departments, each of which are all updated daily. I need to save the "master" excel once a week into a different excel with all the values pasted. This creates a weekly snapshot of the data as it is...
  10. bfreescott

    ADO over VPN

    Whether we're talking about ADO or DAO, the best use case for me has been querying data sets, some of which are Excel files. As long as the data source exists on the same network, the speed of ADO over an ACE connection far outperforms a WORKBOOK.open approach. I've noticed however that when...
  11. L

    VBA - Overwrite current data with text file data

    Hi all I have the following code that works to an extent. Unfortunately, it inserts the data and shifts all other cells to the right. I need it to overwrite the existing data. Any help is appreciated! 'Import text dates Sheets("Split Request").Select Set ws1 = ActiveSheet...
  12. J

    Changing file explorer directories to Sharepoint directories

    Good afternoon I have a number of Excel files which use VBA to create 'dynamic' filepaths, which then proceed to do whatever is needed of them For example: Var1 = [directory root] Var2 = [month] var3 = [Filename] FullFilePath = Va1 & "\" & Var2 & "\" & Var3 ... and then the rest of the script...
  13. J

    VBA

    Hi i News help to creat a code in vba in order to copy a line and paste it as values all the times needed until a condition is met, in this case =0
  14. D

    how to refresh specific groups/queries

    Hi i am wondering if there is a way to refresh a group of queries using vba one group is called "Source data" or if that is not possible is there a way to refresh specific queries, some are connection only and others are tables example of queries: "filepath_New" "file_Path_Code_Old" thank you!
  15. V

    VBA code - copy, paste and delete on entire sheet

    help please, We have the following data where in data sheet we have multiple entry, we have also recored a macro and want to it will run in whole sheet, help please we are copying the data Sheet1!C3:C6 and pasting as transpose on Sheet1!C2 and after that copying the Sheet1!G6 to Sheet1!G2 and...
  16. W

    Excel (BOM) Bill of Material

    I have the following table that is loaded automatically I need to somehow create a table that relates the part number and components at all levels, returning the result as below.
  17. Anigito

    Get Webpage Title Text by URL Generated in MS Excel

    Dear Community, I request your support with the following program (I have reviewed the posts in this forum, but could not find the right one for me). The program should create URL, send request to webpage, get webpage title, process webpage title, write processed data to file, apply hyperlink...
  18. V

    Excel VBA - formatting the bulk data

    Hi, we have the following sheet, where we have some data and want to format them in a fix problem is that, there is two type of questions, one have four option and other have some statement and after that option, please check and update Data ABC11Supreme Court of India ba2(A)Examine...
  19. T

    How to compress all pictures in Workbook

    I am trying to cycle through all the sheets in my workbook and compress all pictures. I know there is a way to save my file with this option, but I would like to put this in the VBA so that it would be triggered each time the file is closed. I tried to search the interwebs and it gave me a...
  20. L

    Evaluate each cell in a row against two other rows using VBA

    I have a lot of data (~350 rows) that need to be evaluated against two rows. Imagine the first row is a header, second row and third row are my spec limits. I am basically trying to evaluate whether each of the 350 row items fall within the values specified in Row 2 and Row 3. I will eventually...

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