Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    137

    VBA Not working help improve

    Dear Experts
    I wrote a VBA copy bits from here and there. It worked fine, the day I created, But now it's giving continuous error. It stops at the Red highlighted point and gives error. Can you help...
  2. Re: Use a target cell value to filter

    Aah Fluff. I just changed my code as below and it did the magic for me in a fast and efficient way... Thanks a lot ��


    Sub IIVRglobal()
    Dim Fltr As Range
    Set Fltr = Cells(rows.Count,...
  3. Re: Use a target cell value to filter

    Thanks for your support Fluff. I am quoting my entire vba code here. Can you help me identify where the mistake is... Honestly I'm a novice and work with small information I gather over net...


    ...
  4. Re: Use a target cell value to filter

    My mistake Fluff. I used it as a seperate VBA & Got Message...

    A 2254
    1

    "A 2254" is the value I wanted to use as filter, what this "1" is I can't understand...

    And this time it filtered as...
  5. Re: Use a target cell value to filter

    Thanks Fluff for writing back. Surprisingly got no message...


    Dim varSr As Range

    Set varSr = Cells(rows.Count, Range("Visits[[#Headers],[SR]]").Column).End(xlUp)
    MsgBox Fltr.Value &...
  6. Re: Use a target cell value to filter

    Thanks for replying Fluff. Somehow, it didn't work. I tried both xlUp & xlDown. It is not filtering... Am I missing some trick?



    Dim varSr As Range

    Set varSr = Cells(rows.Count,...
  7. Use a target cell value to filter

    Dear Expert

    I have to filter my worksheet quite frequently on the basis of value in the last cell of a column. Please help me form a vba for that. I'm sharing the amount of work I was able to...
  8. Re: Copy Paste Only Border Style and No Other Formatting in Excel for Mac 2019

    Someone help...
  9. Copy Paste Only Border Style and No Other Formatting in Excel for Mac 2019

    Hi Experts
    Need some help

    I want to Copy Paste Only Border Style and No Other Formatting in Excel for Mac 2019

    I got this code from some site, but it copies entire formatting. Please help me...
  10. Re: Want Macro to continue after a first action

    Thanks @Fluff for quick response.

    It did the Magic...

    Thanks again.
  11. Want Macro to continue after a first action

    Hi Experts
    Need some urgent help

    I'm working on a macro where I want macro to go to a particular date and then perform another function. So I picked coding from my previous macros and compiling a...
  12. Re: VBA to Select Ungrouped Table Rows

    Humble Thanks to Everyone who didn't help, it motivated me to solve the problem myself.

    Thanks Again.
  13. Replies
    4
    Views
    231

    Re: Formula Issue

    Trim function is best suited to your need - It automatically eliminates Blank entries and extra spaces. Hope it helps
  14. VBA to Select Ungrouped Table Rows

    Hi Experts
    I have a table where I have rows grouped above and below and only few rows remain visible. (I'm attaching table picture for reference)

    Now I need a vba where I could select all visible...
  15. Filter Field using Input Box in Excel 2019 Mac

    Hi Experts
    Here comes a new problem.

    I want to filter a field "Sr" in my table "Visits". The field "Sr" contains data in form "A 0001" and counting goes on.

    So I want to filter giving input a...
  16. Re: VBA to change zoom of all Worksheets in a workbook Excel 2019 for Mac

    @My Aswer Is This

    This code worked for me. Thanks
  17. Re: VBA to change zoom of all Worksheets in a workbook Excel 2019 for Mac

    @My Aswer Is This

    I need to modify my code where it makes every sheet active by itself and changes the zoom level.
  18. VBA to change zoom of all Worksheets in a workbook Excel 2019 for Mac

    Hi Experts,
    Here comes a new problem. With Excel 2019 for Mac, when you open a file, it doesn't display Customised Macro Buttons.

    The workaround is to change the zoom level and they all...
  19. Re: VBA to Filter Before a Date using Formula

    Hi @Fluff

    It did the magic. Thanks
  20. VBA to Filter Before a Date using Formula

    Hi Experts

    Got another problem to resolve

    I want to filter my records for dates before 10 yrs from today. So I have written following code, which is not working. There must be some technical...
  21. Re: Code to Clear Search Box in Excel for Mac 2016

    MrExcel Please help

    I'm on mac. Excel 2016. can't find any way out...

    The keys I use -

    Command + F to reach search box
    DELETE to Clear Search

    But I want to automate it, as part of...
  22. Re: VBA to Group and Hide Multiple Rows

    Thanks Ramballah for quick response.

    I improvised taking idea from your code and that worked perfectly for me.

    I just removed one line from my code and final code looked like this -


    ...
  23. VBA to Group and Hide Multiple Rows

    I want to group and hide multiple selected rows. But the code I have written Group & Hide only one row.

    There must be some technical mistake in the code.

    Please Help


    ...
  24. Re: Code to Clear Search Box in Excel for Mac 2016

    Just to give you an idea why I need it and how I will be using it -

    Normally, at the end of my consultation sessions, I run a script that updates (or brings back) all my worksheets to the formats...
  25. Re: Code to Clear Search Box in Excel for Mac 2016

    I search Manually. But I want to clear Search box with vba code...
Results 1 to 25 of 53
Page 1 of 3 1 2 3