Error in VBA/Excel in simple command

Question

I did not use VBA for a while and I have an error 1004 when using this very simple command. I don't know what I have wrong there as it is very basic. (the range "start" is defined in the sheet "Output")

thanks a lot for your help

Sub simple()
    Dim under_unit As Variant
    under_unit = ThisWorkbook.Worksheets("Output").Range("start").Value
End Sub

Are you sure the named range is in the worksheet scope and not the workbook scope? — Scott Craner
– Scott Craner, Commented Jun 8, 2016 at 19:06

TessellatingHeckler · Accepted Answer · 2016-06-21 18:17:07Z

0

'make sure you have named the cell as: start; and the tab as: Output

Sub simple()

    Dim under_unit As Range
    Set under_unit = ThisWorkbook.Sheets("Output").Range("start")

    under_unit.Value = "solved"

End Sub

edited Jun 21, 2016 at 18:17

TessellatingHeckler

29.3k4 gold badges55 silver badges96 bronze badges

answered Jun 8, 2016 at 21:18

Rodrigo Couto

12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error in VBA/Excel in simple command

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related