View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MAXX MAXX is offline
external usenet poster
 
Posts: 2
Default Q: UDF with Interior.colorindex Help needed

Hi
I wrote a short function "interior"

Function interior(Rng) As Integer
Application.Volatile True
interior = Rng.interior.ColorIndex
End Function

And that works if I call a function with for instance =interior(c3) an i got
color index of cell c3
but I need color index of cell that contains the function ,
something like if in C3 I put =row() I will got 3

How to do this?

Thank you for reading this especially if you are able to help me out on
this.
Maxx