locked
Select method failed RRS feed

  • Question

  • Hi,
    Why is there issue like

    due to last line below?

                        ...
                        Str0 = Trim(Worksheets("Manifest").Cells(Ser0, 4).Value) & "_S"
                        ...
                        S1 = CStr(i): Fill_Border "A" & S1 & ":A" & S1: Fill_Border "B" & S1 & ":B" & S1: Fill_Border "C" & S1 & ":C" & S1: Fill_Border "D" & S1 & ":D" & S1
                        
                        If i > 2 Then
                            Worksheets(Str0).Columns(1).Select


    Many Thanks & Best Regards, Jackson Chen

    Tuesday, October 27, 2020 9:52 AM

Answers

  • Is Worksheets(Str0) the active sheet? If not, you have to activate it first:

                           Worksheets(Str0).Select
                           Worksheets(Str0).Columns(1).Select


    Regards, Hans Vogelaar (https://www.eileenslounge.com)

    • Marked as answer by Jackson_1990 Wednesday, October 28, 2020 2:44 AM
    Tuesday, October 27, 2020 10:18 AM