View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jason Jason is offline
external usenet poster
 
Posts: 367
Default activecell.address problem

Hi,

I'm using Office XP, I'm having a problem referencing the address of the
activecell. Here is a snip of my code

insertFormula(intcount, ActiveCell.Address(False, False, xlA1)

which is passed to

Function insertFormula(intcount As Integer, ByVal Target As Range) As String

I keep getting a 'Type Mismatch' error that highlites .Address.

Help is much appreciated.
Jason