Thread: ActiveCell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] gsteinberg@satorigroup.com.au is offline
external usenet poster
 
Posts: 1
Default ActiveCell

Get a funny problem which was working.

Have the following. I enter 3453 in C15.

in VB have the following

Dim InputRange as Range
Set InputRange = Activecell

This should return C15 (or the active cell address). Instead it keeps
returning 3453.

This was working previously - any ideas - only thing I can think of is
the Excel is 2003-SR1

Desperate to get this working

Thanks