Excel - Find&Replace: Replace String not cell value

Scripting Forums AppleScript | Mac OS X
,
#1

I have the data below on a worksheet.

Objective:

  1. Find and replace all occurrences of “February” and replace it with “March”
  2. Instead of specifying a range is there any way to specify the entire worksheet?

Problem:

  1. Does the objective 1 above but it replaces the entire cell to March. So if you have “February Date” it changes it to “March” rather than “March Date”

Data:
February
February
February Date


tell application "Microsoft Excel"
	activate
	try
		repeat
			tell (find range "A:N" what "February" with match case) to set value to "March"
		end repeat
	end try
end tell

Any help would be appreciated.

#2

thank Jacques. But unfortunately this doesn’t resolve the following problem:

#3

Got it working.

Here you go:


tell application "Microsoft Excel"
	activate
	replace range "A:A" what "February" replacement "March" with match case
end tell

Another question is how do you select the entire worksheet instead of the range

#4

thanks but I just wanted to replace the text not the entire cell.

but do you know how to select the entire worksheet instead of the range??