excel - VBA error message "out of range" when referring to worksheet codename -
i want insert number, entered in inputbox, table tabelle10 after clicking on submit button got message "index out of range" mean? there wrong code?
if insertnumber>= 0 sheets("tabelle10").range("f" & lastcell+ 1) = insertnumber end if
thx help.
according comment, tabelle10
sheet's codename, not name. therefore, should refer by
tabelle10.range(...)
instead of
sheets("tabelle10").range(...)
the "codename" name appears in vba editor's project pane, while "name" 1 appears in tab bar of excel. codename should used in vba object variable.
Comments
Post a Comment