thanks Gord

where do i paste this "=Personal.xls!getcolour(range)"
in the code below (as you may of guessed, i'm upto spped with this VBa

Function getcolour(mycell As Range)
getcolour = mycell.Interior.ColorIndex
End Function

Have tried:
Function Personalxls!getcolour(mycell as range)
getcolour = mycell.Interior.ColorIndex
End Function

but got error

thanks in advance


Gord Dibben wrote:
=Personal.xls!getcolour(range)

Gord

Hi

[quoted text clipped - 19 lines]

thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201003/1