View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Macro to insert row at the end of sheet

Do you use a button from the Forms Toolbar ?
It is not working if you usa a control toolbox button

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Nuzza" wrote in message ...
This line of code seems to be causing problems:
rw = ActiveSheet.Shapes(Application.Caller).TopLeftCell .Row - 1

When I run the macro and get the "Run-time error 13: Type mismatch" error
then click on Debug, that line of code is highlighted in yellow.