Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Function won't work!
Can anybody please enlighten me why this Excel VBA function* works:
Function topright(values) topright = values.Offset(0, values.Columns.Count - 1) End Function and why this one does not (it alwasy returns a #VALUE! error): Function topright(values) topright = values.Offset(0, values.Columns.Count - 1) * 2 End Function Help, would greatly appreciated before insanity sets in. * this function, by the way, is supposed to find the top right hand value in any excel range. So if, in Excel, you did =topright(A1:F5), the function would return the value in A5. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function doesn't work | Excel Worksheet Functions | |||
need a function that will work using multiple work books and sheet | Excel Worksheet Functions | |||
Why does my Function not work? | Excel Discussion (Misc queries) | |||
NZ function doesn't work! | Excel Programming | |||
Why it can work in Function but ok in Sub | Excel Programming |