Active Cell property - Visible?

[Devo]

Hi

I'm a bit of a VB novice so this is probably a very simple question for the gurus..

I'm running Excel 2000 under WindowsXP.

I'm trying to determine if the selected cell on a sheet is visible after the macro applies an autofilter before proceeding with the rest of the macro.

I have tried using the following code

If ActiveCell.Hidden = True Then
        MsgBox "Select one visible Employee Name", vbOKOnly + vbInformation
        Exit Sub
    End If

...but I get the following error:

Run time error 1004
"Unable [/indent]to get the Hidden property of the Range class"

I would be very grateful if someone has a solution to this.

Regards

Devo

[prakashsakthivel]

Hi

I'm a bit of a VB novice so this is probably a very simple question for the gurus..

I'm running Excel 2000 under WindowsXP.

I'm trying to determine if the selected cell on a sheet is visible after the macro applies an autofilter before proceeding with the rest of the macro.

I have tried using the following code

If ActiveCell.Hidden = True Then
        MsgBox "Select one visible Employee Name", vbOKOnly + vbInformation
        Exit Sub
    End If

...but I get the following error:

Run time error 1004
"Unable [/indent]to get the Hidden property of the Range class"

I would be very grateful if someone has a solution to this.

Regards

Devo

Hi

I think only we can apply Hidden property ex either 10th row or A column
not single cell.

could you please go to excel then do it manually


Regards

Prakashsakthivel