try,
Sub test()
'True=hide
MsgBox checkColumnshide(3)
End Sub
Function checkColumnshide(i As Integer) As Boolean
checkColumnshide = Columns(i).Hidden = True
End Function
--
天行健,君*以自強不息
地勢坤,君*以厚德載物
http://www.vba.com.tw/plog/
"stickandrock" wrote:
I want to create a macro that will validate whether a column is hidden or
not. I can make column hidden and/or unhide columns, but it is redudant if
they are already in the state that I need them.
Thank you for any and all input.