Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using ActiveSheet in a Sub to insert a picture into a workbook,
like this: ActiveSheet.Range(tsRangeIn).Select ActiveSheet.Pictures.Insert( _ "C:\inetpub\wwwroot\Images\sig.jpg").Select There are two places from within a single class file where the sub is called. Every time I call the sub from one of these places in the code, I get an "invalid procedure call or argument" error when setting the Range property. The other call to the Sub works correctly every time. Is there anything about the ActiveSheet that may cause it to bomb depending on the context its used in? I'm rather new to VB Excel programming, so any help is appreciated. Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ActiveCell or ActiveSheet | Excel Worksheet Functions | |||
ActiveSheet.Name? | Excel Programming | |||
ActiveSheet | Excel Programming | |||
ActiveSheet | Excel Programming | |||
ActiveSheet | Excel Programming |