Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 1.60 seconds.

  1. Re: Change activesheet name and sheets added dynamically

    Perhaps.


    Sub NameSheets
    Dim cnt As Long
    Dim I As Long

    For I = ActiveSheet.Index To ActiveSheet.Count
    cnt = cnt + 1
    Sheets(I).Name = "WS" & cnt
  2. Re: VBA USERFORM : Search and Find a String and Remove from the Combobox List

    Where are the values you want in the dropdown located on the sheet 'Inconsistency Order'?

    Is it always that sheet you want the values from?

    What if there is unique value with ' check' after it?...
  3. Replies
    4
    Views
    46

    Re: Moved PDFs from one location to another

    Perhaps something like this.


    Sub SaveasPDF()

    Dim wsA As Worksheet
    Dim wbA As Workbook
    Dim strName As String
    Dim strPath As String
    Dim strSavePath As String
  4. Replies
    4
    Views
    93

    Re: out of memory with small array

    Where in the code are you getting the error?
  5. Replies
    2
    Views
    65

    Re: Large Spreadsheet, VBA code is hanging.

    You should ditch Find. and as well as putting the values from column A of 'Location Summary' in an array put the values from column A of the other sheets into arrays.

    Perhaps something like this...
  6. Re: moving pages from one workbook to another fast

    Are there more than 89 sheets in the second workbook?
  7. Re: moving pages from one workbook to another fast

    Are you combining all 189 sheets in a new workbook?
  8. Replies
    14
    Views
    200

    Re: Cool Class for making Floating Shapes !

    Jaafar

    Windows 10 64-bit.
  9. Re: Assigning Macro to Cell and Running Macro Once Entry in Cell is Complete Without Opening Macro Run Window

    Jenn

    You can't assign a macro to a cell/range, however you might want to consider using the worksheet Change event.

    The worksheet Change event is triggered whenever a change is made on the...
  10. Replies
    14
    Views
    200

    Re: Cool Class for making Floating Shapes !

    Jaafar

    It's Office 365 32-bit.
  11. Replies
    8
    Views
    156

    Re: Looping through an Array

    Have you considered using an array for the results?

    i.e. loop through the input array and, based on the criteria, populate another array and then use the second array to put the values in the sheet
  12. Re: VBA Code to Reference another Macro and Fill Dialog Box Based on Cell Entry

    Are you sure that code is displaying the pop-up?

    Have you tried stepping through it with F8 to see which line of code is causing the pop-up to display?
  13. Re: Adding another dimension to an array and preserving

    What are you going to use the extra dimension for?
  14. Re: VLookup path coding to point to another workbook

    You can't use Application.Vlookup with a closed workbook.
  15. Replies
    18
    Views
    159

    Re: quick question VBA and arrays

    Here's the same code without the With.


    setup = Worksheets("Lead").Range("b1", Worksheets("Lead").Cells(2, setlastcol))


    Not sure if it's any more efficient but it is longer.:)
  16. Replies
    18
    Views
    159

    Re: quick question VBA and arrays

    Try this.


    With Worksheets("Lead")
    setup = Worksheets("Lead").Range("b1", .Cells(2, setlastcol))
    End With


    PS That's not really an array question, more to do with how you are...
  17. Replies
    8
    Views
    156

    Re: Looping through an Array

    Roderick_E

    What are you actually doing with the array?
  18. Re: VBA Code to Reference another Macro and Fill Dialog Box Based on Cell Entry

    I don't see how you can do this without changing MacroA.

    To find out which macro is assigned to a buttton right click the button and select either Assign Macro... or View Code, whichever appears...
  19. Replies
    6
    Views
    82

    Re: dot - what before?

    If there's no With then the code won't compile, you'll get an 'Invalid or unqualified reference' error.
  20. Re: VLookup path coding to point to another workbook

    Is the workbook Database.xlsm open?
  21. Replies
    14
    Views
    200

    Re: Cool Class for making Floating Shapes !

    Jaafar

    All I'm getting is small userforms with the shapes displayed.

    Also the options in the right click menu are greyed out.

    Yongle

    The Interface code needs to be in a class module name...
  22. Re: Difference between If, Then ActiveCell vs If, Or, Then ActiveCell

    I'm afraid neither set of code will compile so I'm not sure how they can be compared.

    Is this perhaps what you wanted to compare?


    If ActiveCell = " " Then
    ActiveCell = 0
    Else
    ...
  23. Replies
    10
    Views
    246

    Re: Application.Match

    Henrik

    You need to check if Application.Match has returned an error, which it will do if there's no match.


    Dim arr As Variant, a As Variant, total As Double, res As Variant

    arr =...
  24. Re: Control Userform labels and buttons with VB macro

    I downloaded the file and the code I posted worked.
  25. Re: Control Userform labels and buttons with VB macro

    Rod

    Try this.


    Private Sub UserForm_Initialize()
    Dim lngCounter2 As Long
    Dim Label As String

    For lngCounter2 = 56 To 78
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4