clearcontents

[Curt]

call sub from entry in column 12 want called sub to clear entry in column 16
when 12 => than 16 this needs to work in all rows. Know I'm missing something
Tried this to no avail
Thanks

Public Sub Pledge(ByVal target As range)
Sheets("data").Select
target("16").ClearContents
End Sub

 

[Jay Freedman]

call sub from entry in column 12 want called sub to clear entry in column 16
when 12 => than 16 this needs to work in all rows. Know I'm missing something
Tried this to no avail
Thanks

Public Sub Pledge(ByVal target As range)
Sheets("data").Select
target("16").ClearContents
End Sub

This is clear as mud, but one thing stands out: You're working in Excel, and
this newsgroup is about VBA in Word, so you're in the wrong place.

 

[Curt]

sorry

This is clear as mud, but one thing stands out: You're working in Excel, and
this newsgroup is about VBA in Word, so you're in the wrong place.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.

 

[Tony Jollans]

Peering through the mud, I don't believe it can be done; UDFs in cells
cannot alter other cells. The code needs to be called from the cell(s) in
column 16, or in some event.