Search:

Type: Posts; User: Kamolga; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    2
    Views
    13

    Re: VBA Email notification

    There is an open workbook event: In VBA, 2x click "ThisWorkbook" under the sheets name and paste



    Private Sub Workbook_Open()
    With ActiveSheet.MailEnvelope
    .Introduction = "File 123...
  2. Timeline slicer: 2x click total of the pivot provides too many lines

    Hi,

    I have set up a timeline slicer on a pivot for a tool in Office 365. The users use Office 2013 and the pivot behaves exactly the same on both versions: if we put the slicer on today's date, we...
  3. Re: Lookup a value and then find the largest in a range

    Hi,

    I use the max formula on a line and set up the number of line with a match in the column. Indirect put them together.

    ...
  4. Replies
    5
    Views
    390

    VBA CommentThreaded 'show'

    Hi,
    I would like to show a threaded comment (with notes it is straightforward, we put them on 'visible=true') when activating a sheet.
    Is there a line of code to show those threaded comments ?
    ...
  5. Replies
    2
    Views
    186

    Re: Macro button on desktop

    It is possible to have a
    file or shortcut which, when you double click it, hides application and shows a userform only on opening event


    Private Sub Workbook_Open()

    Application.Visible =False
  6. Replies
    5
    Views
    278

    Re: 'Match' a range, skip a predefined cell

    In VBA, once you have the values, instead of looping 3 times through the range (in this example it does not mater because it is small but maybe you will increase it), you can use Range.findnext to...
  7. Replies
    5
    Views
    278

    Re: 'Match' a range, skip a predefined cell

    For M,
    I reduce range if countif first value is bigger than 1. I therefore look for large 1 in column 8+1 to 10, so I-J (I use substitute to get from 8 to H) and indirect to have range I1:J1


    ...
  8. Re: Extending a configuration to multiple rows

    I would make one big range from line 2 to to 200 then 'case select' leaving the 'case else' empty


    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target,...
  9. Re: Macro to prevent or answer Excel recovering windows

    In File/options/advanced you have at the very end an option to 'update links to other documents' in 'when calculating this worbook' segment. It can be set up by Activeworkbook.UpdateRemoteReferences...
  10. Re: Macro to prevent or answer Excel recovering windows

    Indeed.

    In your new file, you can check 'existing connection' in your data tab.
    Formulae as long as within the workbook are fine, might have troubles if linked to other workbooks that are closed...
  11. Re: Macro to prevent or answer Excel recovering windows

    Hi,

    I try to reproduce your error but I have no message. Indeed I can close it without any message and when I open it, I have a 'enable editing' (like when I receive a file from someone) on top of...
  12. Replies
    5
    Views
    209

    Re: How to loop the VBA Code

    You can select a bigger target (in my example rows 12-32) and apply it to the row instead of looping:


    Private Sub Worksheet_Change(ByVal Target As Range)
    'Change in B column
    If Not...
  13. Re: Is there a way to trigger a sub from inside another sub?

    To use a function, you just need to put the name and the elements (in this case
    strDir as text and
    strPath as text), so


    Sub btnclick


    MkDir("Directory you want","Path you want")
    End sub
  14. Replies
    5
    Views
    441

    Re: VBA - Slicer Selection

    I would run the macro on

    Private Sub Worksheet_Activate()


    End Sub

    if you want to launch it on an event.

    I would also store the value in a ActiveWorkbook.Names("XXX") using Define...
  15. Replies
    5
    Views
    441

    Re: VBA - Slicer Selection

    Hi,
    When you calculate it, just name it. In this example I will name it Val and just says it equals 29 but you can use whatever calculation you want.

    Dim Val As Long: Val = 29

    The captions...
  16. Replies
    11
    Views
    447

    Re: Code to get worksheet name into a cell

    You just need to save as since the formula is based on filename, then any calculation will update the value.
  17. Replies
    6
    Views
    382

    Re: SUM of cells that contain data

    Basically you just need to select 12 sheets (click sheet 1, press shift, then sheet 12) and type formula to have the count on 12 sheets. Sheet1:Sheet12 to have the count of 12 seets.
  18. Replies
    9
    Views
    328

    Re: Trying to obtain the ROI value for an investment portfolio.

    You are welcome, thanks for the feedback
  19. Replies
    11
    Views
    447

    Re: Code to get worksheet name into a cell

    =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
  20. Replies
    9
    Views
    328

    Re: Trying to obtain the ROI value for an investment portfolio.

    One thing could be that March is text. You need to enter it as 01/03/2019 and use format, more number format, select the last one 'custom' and Type "mmmm" (without " "). So you will read March but...
  21. Replies
    9
    Views
    328

    Re: Trying to obtain the ROI value for an investment portfolio.

    Hi, this would sum what is in column A if the date in column E is bigger or equal to 1st July 2019 and and smaller than 1st August 2019

    ...
  22. Replies
    9
    Views
    328

    Re: Trying to obtain the ROI value for an investment portfolio.

    Nobody can add an attachment to their post.
    There are tools to copy-paste excel, I installed an add-in for that but the simplest way is to use the snipping tool (installed with windows) to select...
  23. Thread: Probability

    by Kamolga
    Replies
    7
    Views
    385

    Re: Probability

    You are welcome. Thanks for the feedback.
  24. Replies
    6
    Views
    382

    Re: SUM of cells that contain data

    If you have columns A,b,c and rows 1 to 18, then your workdays are the amount of cells filled with data in range B1:C18

    =Count(B1:C18) will count it for you.
  25. Replies
    9
    Views
    328

    Re: Trying to obtain the ROI value for an investment portfolio.

    It is difficult to understand what your error could be since we have no data. Are A, F and J percentages? If so can you add them (all same base)? If not percentages, you miss brackets to get a...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4