Search:

Type: Posts; User: Johnny C; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Re: Links updating in VBA incorrectly to values previously overwritten???

    Sorted.

    It's another odd bug. Or it may be my misunderstanding, though I don’t think so as it’s not consistent.

    I have a load of spreadsheet, which are linked in 1 direction.
    File A has a...
  2. Links updating in VBA incorrectly to values previously overwritten???

    I've got 2 files, one with a sheet linked to the other so that they are the same sheet.
    The sheet linking to the other one is "Forecast - 8 - Output - 2020-23.xlsb"
    On sheet Constants, the formula...
  3. Re: VBA clipboard going wrong when File Explorer open

    Cheers Rory. Done and it works fine now.

    Finally - LongPtr data type used.

    Pointers bring back bad memories of long hours scratching our heads when writing compilers in Pascal. Excel pointers...
  4. VBA clipboard going wrong when File Explorer open

    I've got this code attached to a button on my QAT. it copies the file path, filename, sheetname and selection range to the clipboard so that it can be quickly pasted into the sheet or emails.

    It...
  5. Links updating incorrectly with a #DIV/0 error when source data is pasted values

    I have a file linked to another.

    Nothing fancy, 3 rows 4 columns in columns D-G with the formula

    ='F:\[Historic costs.xlsb]Historic costs'!B14
    copied down and across.

    When I open the file...
  6. Re: SUM based on 3 criteria but only the latest date - Excel Function

    Hi. the tilda is messing it up. Change ~ to ^ or some other character that will never be in your values, I tested it and it worked
  7. Re: SUM based on 3 criteria but only the latest date - Excel Function

    See my original message
    You can make a helper column in F1:F10 with the formula =A1&"~"&B1&"~"&C1&"~"&E1 in F1 and copy it down
  8. Re: VBA for copy/paste values of all workbooks in a folder

    This might set you on your way. Note that some sheets have VBA Codenames (wksSupplier) so go into VBA and give your Sheet1 in the master a codename and replace wksSupplier with that codename in the...
  9. Re: Excel Round off formula to get desired result

    =(ROUND(X*2.57/100,0)*100 should fix it
  10. Replies
    5
    Views
    53

    Re: check if folder exist with wildcards

    I doubt that is possible. You will need to loop through all the subfolders under C:\Users\ and test if C:\Users\subfolder\Desktop\New folder\ exists and set a flag or count in the loop.

    Unless you...
  11. Re: SUM based on 3 criteria but only the latest date - Excel Function

    There is a risk with =SUMPRODUCT((A1:A10=A12)*(B1:B10=A13)*(C1:C10=A14)*(E1:E10=MAX(E1:E10))*(D1:D10)) in that it will only work if the max date exists for the combination of A12-A14.
    If...
  12. Re: Formula Request: Sum across different sheet tabs with dynamic range, without INDIRECT

    What you can do is add the cell reference to the indirect.

    e.g.
    =SUM(INDIRECT("BEG:END!"&CELL("address",BEG!E257))

    Then when you insert a row to the BEG sheet the formula would automatically...
  13. Re: Can I get this macro to run all the code before opening the PDF?

    Unfortunately there's no foolproof way. Excel doesn't 'handshake' with other applications, it fires off the Sheets("Fee Proposal PDF").ExportAsFixedFormat command then gets on with the next...
  14. Re: SUM based on 3 criteria but only the latest date - Excel Function

    Which version of Excel do you have? if you have Excel 2016 you can use the MAXIFS function.

    You can make a helper column in F1:F10 with the formula =A1&"~"&B1&"~"&C1&"~"&E1

    This would get you...
  15. XL2016 When I delete a series that series stays and the rest disappear?

    Different issue to the previous one but vaguely related.

    I have charts set up in XL2013 32 bit, I've now got XL2016 64 bit with secondary axis.

    When I select a series and click (or press)...
  16. Chart series disappear in XL2016 when secondary axis changed

    Help!

    I've got a large model with 30+ charts. They were created in XL2013 32bit, I've now got 2016 64bit.

    When I try and amend the bounds (upper or lower) for the secondary axes, all the chart...
  17. Replies
    4
    Views
    1,013

    Re: Spreadsheet audit software

    Hi
    Inquire half does what we want. It covers most things, it doesn't cover VBA. I don't know about Get & Transform, we're still on XL2013. It does flag up some useful stuff like external references...
  18. Replies
    7
    Views
    206

    Re: double click userform

    Thanls Norie.
    IIRC BeforeDoubleClick isnt listed as an option on wrksheet events, or it didnt used to be but you could still use it.
  19. Replies
    7
    Views
    206

    Re: double click userform

    I'll have a look tomorrow. My PC is running an all-night job at the moment.
  20. Replies
    2
    Views
    485

    Re: Excel to Word -> VBA -> Canvas?

    You use VBA to add the lines and shapes, you don't need any external tools.

    Are the shapes already in Excel? if so you copy and paste them
    e.g.

    Sheets("MySheet").Shapes("Shape 1").Copy
    ...
  21. Replies
    3
    Views
    132

    Re: Interest Calculation - VBA

    I think your problem is here:

    Do Until Count = 6 Or Running > stp

    Count = Count + 1
    mth = monthly + mth
    MsgBox mth
    Total = Total + (monthly * Count)

    Loop
  22. Re: Printing Word Documents based on Excel Sheet

    Try here
    https://stackoverflow.com/questions/1419829/print-a-word-document-without-opening-it-using-excel-vba

    Put the loop to loop through your cells in this bit:

    Set objDoc =...
  23. Replies
    7
    Views
    206

    Re: double click userform

    you need to go to the code for the worksheet, and create a worksheet_DblClick event with something like this:

    If target.col = 1 and target.row = 1 then Call LoadForm (or whatever your macro is)
  24. Re: Excel VBA - copying range to Powerpoint crashes Powerpoint instantly

    This is the thread that explained it:-
    https://stackoverflow.com/questions/16338295/excel-to-powerpoint-vba-pastespecial-keep-source-formatting
  25. Re: How do I return focus to Excel after copy to Powerpoint?

    Solved...

    it needed this in the macro that opened the Userform.


    AppActivate ("Microsoft Excel")
    Application.ScreenUpdating = True
    AppActivate...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4