Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cells(row, j).Interior.colorindex | Excel Programming | |||
more on interior.colorindex issue | Excel Programming | |||
interior.colorindex does not work? | Excel Programming | |||
Use of Interior.ColorIndex | Excel Programming | |||
Testing for Interior.ColorIndex | Excel Programming |