1. W

    Adding/updating text between a string or cell with text

    I have the following stored in a string (can be in a cell as well, if needed). Let's say s_String1(2,1) or cell A2: This text is permanent //Changeable-Text-Starts-Here This text can be changed by macro //Changeable-Text-Ends-Here This is also permanent I want to be able to remove...
  2. J

    Refresh spreadsheet when listbox updated

    Hi, I need help writing a vba code which had 7 textboxes and an update button to update the listbox then spreadsheet updated via the listbox. base on the colunm selected from the listbox, it populates through the textboxes. when selected column from listbox is selected, update is made via the...
  3. S

    Excel VBA relection bug

    Hi, I have the weirdest bug. I have a simple macro that goes like this: Sub Update() Application.Calculation = xlManual ActiveWorkbook.RefreshAll Range("A20").Select Application.Calculation = xlAutomatic End Sub When I use this code, all goes well, but I later get a...
  4. H

    macro to Update Formulas on all Sheets (F9)

    I have written code to update my formulas instead of manually updating using F9 It is not updating all sheets, only the current sheet Sub Refresh_Formula() Dim ws As Worksheet For Each ws In Worksheets ws.Calculate Next ws End Sub It would be appreciated if someone...
  5. M

    VBA solution to get rid of "update" links message when a file is opened?

    Hi I get two different types of messages when opening certain files with a macro, that I don't want to get. One of them says "This workbook contains links to one or more sources that could be unsafe. If you trust the links, update them, to get the latest data...." Then it gives you...
  6. S

    Indirect within sumproduct

    I have the following formula but want to use INDIRECT function on the column name within the table GANNT so becomes easier to update =IF(F$7<$C$2,0,SUMPRODUCT(--(GANTT[WK40_2]=$B$11))*E$8) Have tried the following but get a #REF...
  7. J

    Upgraded to 2016: Graphs are no longer animated running VBA

    Hello, I did some searching but could not find anything that seemed to work for me so I apologize if this has been asked before: Our office recently did a batch of Windows upgrades and I'm now on Excel 2016. I have numerous macros that will perform iterations and update numbers on the screen...
  8. L

    How to automatically update excel without opening it once per week

    Hi, Right now, once a week I need to open a file, refresh the table, save and close the file. Is it possible for excel to automatically update itself without opening it once per week? Thanks in advance.
  9. D

    Power query - Updating files before getting values

    I have a query that retrieves information from multiple excel files in a folder The problem I am running into is that those files have formulas that depend on the current date Seemingly, when power query retrieves the data, it doesn't allow the formulas to update first This results in incorrect...
  10. P

    Import data from excel and update in browser

    I have two columns in an excel file A - contains the web link B - contains the data to be updated in opened browser as per A. While opening in the web browser (1 as per image) there is drop down option comes at a particular section (2 as per image) > select an option > it will open up...
  11. P

    index match

    Hi I have a table with multiple columns and a form that adds data to each of those columns, as a "case". I also have a separate function that adds data to some of those columns, based on the value in column A as a "case update". How do i get the remaining blank cells in that row to fill with...
  12. T

    Pasting selection into sheet in another workbook fails if excel is opened in another instance

    I have a spreadsheet that imports data from a different workbook to import and update items in the destination book by pasting data from the second workbook... It all works absolutely fine - although in some cases when the second workbook (with the data to import) is opened, it opens in a new...
  13. D

    Some help with a last modified date/time problem

    Hi all, I'm very new to VBA and macros and am struggling to find a solution for what I would like to do. I am using some code that i found to show the date and time that a worksheet was last modified in a given cell. This does not update on it's own. The only way that I am able to update the...
  14. I

    reference multiple tables within search range

    I'm using the below code to check for existing records (in case the user of my UserForm clicks "add record" instead of "Update" 'Checks for existing record in case user clicks Add record instead of update. Dim reference As String reference = UserForm1.Ref_Num.Value Dim aCell As Range 'Set...
  15. J

    Formula based on Quarter

    Hi there, I've racked my brain, and exhausted google searches so hoping someone can help me. I have a bunch of data in a spreadsheet that I do not want to manually update when the quarter turns over. So I'm wondering if there is a way to do a conditional formula (and I know there has to be)...
  16. W

    How can I fetch a web site in VBA without using IE? I now use IE & MSXML... to do fetches.

    Chase Credit Card issued this announcement: Please update your browser.We'll stop supporting Internet Explorer® soon. Choosing another browser will also help protect your accounts and provide a better experience. Update your browser I would prefer to use Chrome ver. 77. Any advice?
  17. G

    environ("username") alternative

    Hi, Hoping someone can point me in the right direction with this one.........thanks in advance. So as part of the company structure individuals have different access to spreadsheets based on their username. Some can only view certain sheets, some read only, some have full access etc etc...
  18. Z

    how to update records through Forms

    Hello Everyone I'm Trying to Update my records through the form i created. not sure if its VBA or not! so any idea ?!:rofl:
  19. S

    Moving Macro to one file

    I have built a macro that pulls data into a master sheet. Can i have this macro sit in one excel file on a network and create a second macro that would be in the data sheets and when clicked would open the network sheet and run the macro on the data sheet? Benefit being I can update the...
  20. L

    highlight cells then change their values

    Hi I want to select/highlight random cells in a table then multiply them by 20% and then update these cells value. for example A1 = A1 * 20% Then after the update, I want to be able to highlight or select or point to the cells that I just changed their values. Similar idea to the Formula...

Some videos you may like

This Week's Hot Topics