macrco

  1. rediffusion

    How to adjust the size of the `Note` after opening it?

    Cross-post ! So here is macro: Private Sub NoteZoom3() With ActiveWindow.VisibleRange NoteChangeSize .Width, .Height, True End With End Sub Private Sub NoteChangeSize(w!, h!, Optional scr As Boolean) With ActiveCell.Comment.Shape .Width = w: .Height = h...
  2. A

    VBA code to merge every three rows starting from second row

    Hi everyone, I need a VBA code that would merge every three rows (if data exists) starting from row 2, and covering column range of A to lets say J. Many thanks in advance,
  3. L

    [VBA] Search worksheet for match and copy/paste

    Hi, I have two excel documents, "Book1" and "Book2". Book1 is exported from our business system. Book2 is a compilation of forecast from the businesssystem data that were exported. Today I have to manually put in the data from Book1 to Book2. I want to put a VBA Code in Book2 to import data...
  4. tlc53

    Macro to add date to column

    Hi there, Can someone help me write this VBA code please? In column K (from K9 down) I have dates or blanks. I want to be able to push a button (POST) and if column K has a date in it (ie. isn't blank) then today's date should be entered in column L (L9 down). Once this date is entered in...
  5. N

    Copy and Export to CSV of a Pivot table output..

    Hi experts, i am an newbie for the VBA and Power Query.. i will have to download reports from our old system and upload to new system everyday.. the downloaded file will have an pivot table output as below after cleaning data. what i need to be do is copy each output based on the kit no and...
  6. S

    VBA Code Creation in Excel

    Please help me on creating a macro which search multiple sheets in a workbook with a particular column name and display the count of values in that column and display in a new sheet with sheet name and the count. Here is my code, Sub Click() Dim sh As Worksheet, ws As Worksheet, LstRw As...
  7. S

    Macro Creation in Excel

    Please help me on creating a macro which search multiple sheets in a workbook for a particular column and display the count of values in that column and display in a new sheet with sheet name and the count. Thanks
  8. A

    Tweak create PDF code

    Hi All, The below code creates a PDF from a named range in cell A55 on the "Menu" sheet and saves this to a folder based in a value in cell A52 on the "Menu" sheet. What I'd like to achieve, is that if the value of cell A115 on the "Menu" sheet is "Zone" then output the PDF file to a path in...

Some videos you may like

This Week's Hot Topics

Top