Empty Cell

[Rod Taylor]

Sorry I First posted this wrong
Hi I need Some Help with My VBA Macro
I want to change either the last occurrence of a value in a cell within the
range or all occurrences to a strikethrough font also the cell two places to
the right.
Then I want to take that same info and place it in the first empty cell in
the range then I will place some other info in the cell two to the right of
that.
The Range Name is CIC_D
The Value is CNT_A,
and the Value to go two to the right of the empty cell is cntbsht
If this requires to different subs that's ok

Next question is if their are no empty cells available then can I add A cell
to the range
hanks In Advance

 

[J.E. McGimpsey]

See one potential response in my reply to your earlier post.

Please stick to one thread - otherwise your replies get fragmented.

See

http://cpearson.com/excel/newposte.htm

for more tips on how to use these groups effectively..