problem using ActiveSheet in VB sub

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

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
 
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"
 
Back
Top