Trying to use "PROPER" function is a VBA program

[hunter.t.j]

My Code:

CellAdd = ActiveCell.Offset(1, 0).Address(False, False)
CellSav = Proper(Trim(CellAdd))

Getting "COMPILE ERROR" Sub or Function Not Defined.

Any Suggestion

 

[VoG]

Try

 CellSav = WorksheetFunction.Proper(Trim(CellAdd))

 

[Richard Schollar]

Hi

Why are you using Trim here? It isn't (shouldn't) be doing anything. Also, why do you want to 'proper' a single cell address?

 

[Norie]

Why are you using Proper for an address?