Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    4
    Views
    908

    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...
  2. Replies
    7
    Views
    159

    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.
  3. Replies
    7
    Views
    159

    Re: double click userform

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

    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
    ...
  5. Replies
    3
    Views
    108

    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
  6. 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 =...
  7. Replies
    7
    Views
    159

    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)
  8. 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
  9. 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...
  10. How do I return focus to Excel after copy to Powerpoint?

    I've written some code to copy charts and ranges to Powerpoint. Powerpoint can't be saved and closed at the end.

    How do I get focus back to Excel after the final paste? here's the code. I've...
  11. Excel VBA - copying range to Powerpoint crashes Powerpoint instantly

    This isn't a question, I resolved it after a morning googling and watching Powerpoint stop working. I thought it might help someone else.

    We have large PPs with a financial forecast (say 60...
  12. Replies
    0
    Views
    843

    A bit of Excel humour ...

    https://goingconcern.com/this-guy-is-why-accountants-on-twitch-totally-needs-to-be-a-thing/
  13. Re: Excel VBA check if chart is part of a group

    Cheers. I was hoping to do it without error trapping but if I can get the group name I can do a prescan I guess to ID charts in groups and not in groups and deal with each separately.
  14. Excel VBA check if chart is part of a group

    Hi

    I'm writing an Add-In so people in my team can copy charts automatically to PowerPoint or Word.
    I just tested it on a file where one of the charts has text boxed and an arrow grouped together...
  15. Replies
    2
    Views
    438

    Getting started with power BI

    Right. I started Power BI this morning for the very first time. I've had no training (the power BI guy here is always too busy).

    I've very familiar with Excel and Access, have worked as a SQL...
  16. Replies
    40
    Views
    764

    Re: Compile error Procedure too large

    Have you got a worksheet_change event in the sheet code?

    There's no need to select anything, selecting just slows it down massively as it needs to do screen refreshes etc after each select. It's...
  17. Replies
    6
    Views
    237

    Re: auto highlight row

    Sorry try this. SpecialCells crashes Excel in Sheet code for some reason so you may need to find a way to get the last row/column


    Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    ...
  18. Replies
    6
    Views
    237

    Re: auto highlight row

    Hi Robert

    Something along these lines would work (I googled it and pasted so you could see the syntax)


    With Selection
    'Delete any previous conditional formatting
    ...
  19. Replies
    6
    Views
    237

    Re: auto highlight row

    The problem is going to be a disconnect between your VBA and your conditional formatting.
    When you go into Conditional formatting, does it have multiple versions of similar things?
    When you have a...
  20. Replies
    7
    Views
    340

    Re: For loop stop on blank

    Assuming utskrift is a sheet you want to vary, something along these lines



    Sub NastaButik()
    Dim v As Variant
    Dim sht as Worksheet

    For Each sht in ActiveWorkbook.Sheets
    If sht.name...
  21. Replies
    20
    Views
    783

    Re: We found a problem with some Content

    A good place to chase it down, go into the File menu and 'Check for issues' where it says Inspect Workbook. That's in Excel 2013, it may be elsewhere or worded differently, or maybe gone altogether,...
  22. Replies
    3
    Views
    207

    Re: Row Number of Last Numerical Cell

    I think you need a helper column. in C2
    =IF(LEFT($B2,1)="N","",ROW()-1) and copy down
    Then your formula would be
    =OFFSET($B1,MAX($B:$B),0)
  23. Non-VBA function to display 'Last modified Data/Time'?

    Hi
    I expect the answer is No as I can't find it with Google, but is there a non-VBA way to update a cell with the date a file was last modified?

    I know there's a myriad of VBA ways but a User...
  24. Replies
    4
    Views
    908

    Re: Spreadsheet audit software

    I saw a reference to Inquire, a COM adding with XL2013. I tried it, it's what we need. A sample run generated an audit file that was too big to send on internal email, I've recommended Inquire and...
  25. Replies
    4
    Views
    908

    Spreadsheet audit software

    Our Internal Risk framework covers Excel models. At the moment, users classify the level of risk associated with each model themselves, as high, medium, low depending on the complexity of the models...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4