Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.34 seconds; generated 6 minute(s) ago.

  1. Re: Copy Data from a column on a sheet and paste to a specific spot on another sheet

    What is the value of UsdRws when you get the error?
    Also does it copy all the data from col G to col I?
  2. Re: Copy and automatically save sheets from a workbook to separate workbooks

    :cool:
  3. Re: Change cell value on multiple worksheets using a wildcard

    If it's only one cell on each sheet, you can do it like
    Dim ws As Worksheet
    Dim ary As Variant
    Dim i As Long
    arr = Array("rateid*", "po*", "xyz*")
    For Each ws In Worksheets
    ...
  4. Re: Copy and automatically save sheets from a workbook to separate workbooks

    Glad to help & thanks for the feedback.
    Not sure whose code you're using, but if it's mine please note the changes in blue I showed in post#13, This prevents the code from crashing if there are no...
  5. Re: Copy and automatically save sheets from a workbook to separate workbooks

    If it's a set path you want to use, try
    Sub gingerbreadgrl()
    Dim Cl As Range
    Dim Ws As Worksheet
    Dim Pth As String

    Pth = "C:\Mrexcel\Fluff\"
    With ActiveSheet
    .Name =...
  6. Re: Copy and automatically save sheets from a workbook to separate workbooks

    Yes there is, but where do you want to save them?
  7. Re: Change cell value on multiple worksheets using a wildcard

    Which cell do you want to change?
  8. Re: Copy and automatically save sheets from a workbook to separate workbooks

    Where do you want them saved?
  9. Thread: 1004 error

    by Fluff
    Replies
    4
    Views
    28

    Re: 1004 error

    You should never use keywords (such as Target) for the names of variables.
    Also looking at your code I would think you'd be better off with a change event, rather than a selection change event.
    How...
  10. Replies
    4
    Views
    20

    Re: Calling a Sub within the Main Macro

    Glad we could help & thanks for the feedback
  11. Re: Copy and automatically save sheets from a workbook to separate workbooks

    Oops, it should be
    For Each Cl In .Range("A2:A" & .Range("T" & Rows.Count).End(xlUp).Row)
  12. Re: Need help merging cels based on another cel

    You're welcome & thanks for the feedback
  13. Re: VBA to hide date columns based on user selection in drop-down list

    You could also use a change event, which will trigger automatically whenever A5 is changed
    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim Cl As Range
    If Target.CountLarge > 1 Then...
  14. Re: VBA to hide date columns based on user selection in drop-down list

    Hi & welcome to MrExcel.
    How about
    Sub ShowMonth()
    Dim MyRange As Range, c As Range
    Application.ScreenUpdating = False
    Application.Calculation = xlCalculationManual
    Set MyRange =...
  15. Replies
    4
    Views
    20

    Re: Calling a Sub within the Main Macro

    You need to do it like
    Sub Format_Workbook_Pt2()
    Call ConvertTextToNumber
    End Sub
    Sub ConvertTextToNumber()
    Sheets("All_Data").Select
    Range("C:C").Select
    Selection.TextToColumns _...
  16. Re: Need help merging cels based on another cel

    How about
    Sub gyagos()
    Dim Cl As Range
    Dim Dic As Object
    Dim Ky As Variant

    Set Dic = CreateObject("scripting.dictionary")
    For Each Cl In Range("A2", Range("A" &...
  17. Replies
    16
    Views
    216

    Re: Isnumber Search Formula

    You're welcome.
  18. Re: Macro to spell check just the words in a texbox?

    Not sure that's possible, other than selecting the text in the textbox & running the spell check.
  19. Replies
    1
    Views
    18

    Re: IF Formula (possibly) or VBA

    With sheet1 like

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  20. Replies
    16
    Views
    216

    Re: Isnumber Search Formula

    It's not designed to work on a range of cells, just 1.
    You need to put the formula on each row in the sheet.
  21. Re: Copy and automatically save sheets from a workbook to separate workbooks

    How about
    Sub gingerbreadgrl()
    Dim Cl As Range
    Dim Ws As Worksheet

    With ActiveSheet
    .Name = "Client Onboarding"
    For Each Cl In .Range("A2:A" & .Range("T" &...
  22. Replies
    12
    Views
    103

    Re: Check to see if sheet exists and rename it

    You're welcome & thanks for the feedback
  23. Re: Copy Data from a column on a sheet and paste to a specific spot on another sheet

    Missed another one of these .
    With Sheets("fitment")
    UsdRws = .Range("G" & Rows.Count).End(xlUp).Row
    .Range("I2:I" & UsdRws).Value = .Range("G2:G" & UsdRws).Value
    ...
  24. Re: Macro to spell check just the words in a texbox?

    Missed the part about it being a shape.
    This makes it easier, you just need to run the spell checker from the Review tab
  25. Re: Object Required error with ActiveX Combobox

    Assuming the the combos are on a sheet, code C works because it's in the relevant sheet module.
    code B (and possibly A) fails because you have not qualified the combo with the sheet name
Results 1 to 25 of 149
Page 1 of 6 1 2 3 4