Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem using ActiveSheet in VB sub
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem using ActiveSheet in VB sub
Matt,
It would fail if the named range was on a sheet other than the activesheet. So when it bombs, have you changed the sheet some way? Activesheet is a dodgy object to use, far better to use a specific sheet object,like so Dim oWsSummmary as worksheet, oWsDetail as Worksheet Set oWsSummary = Worksheets"Summary") Set oWsDetail = Worksheets("Detail") and refer to these specfific objects oWsSummary.Range("myRange").Value = "test" -- HTH Bob Phillips "Matt" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveCell or ActiveSheet | Excel Worksheet Functions | |||
ActiveSheet.Name? | Excel Programming | |||
ActiveSheet | Excel Programming | |||
ActiveSheet | Excel Programming | |||
ActiveSheet | Excel Programming |