How about:

with worksheets("sales").range("g5")
.formula = .formula
end with



dhstein wrote:

I have calculation set to manual. I'd like to recalculate 1 specific cell,
for example G5 on Sheet "Sales". Can I do something like
Sheets("Sales!G5").Calculate? Thanks for any help on this.

--

Dave Peterson