columns("a")

[lezawang]

Hi
Why the code below is giving me an error message. Complaining about Columns("a")? while second line is fine with using Rows(1).

I check the link below and the author used Columns("C") no probelm.
https://bettersolutions.com/excel/rows-columns/vba-code.htm

Thank you so much

Sub myrange_3()
    'access rows and cols
    Workbooks(1).activesheets.Columns("A").Value = 2
    Workbooks(1).activesheets.Rows(1).Value = 1
End Sub

 

[Joe4]

I don't think that is the problem.
"activesheets" is not valid. There is no "s" on the end (it is not plural).

 

[DanteAmor]

Check if you have more open books, Then any of the others can be the workbook(1)

Or try:

Sub myrange_3()
    'access rows and cols
    [COLOR=#ff0000]ActiveSheet[/COLOR].Columns("A").Value = 2
    [COLOR=#ff0000]ActiveSheet[/COLOR].Rows(1).Value = 1
End Sub

 

[lezawang]

Thank you all. I was focusing on Rows and Columns. Thanks a lot once again

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.