Replace word

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Replace word

FAQ

Thread Tools

Display Modes

11-22-2019, 01:21 PM

DIMI

Windows 7 32bit Replace word

Office 2007

Advanced Beginner

Join Date: Aug 2017

Posts: 37

Replace word

Good evening,
I want in sheet1(A1:G50), if client 1 (sheet2(cell(A2)) is german (sheet2(cell(B2)) then select cell(A5) and replace with word 'apple',still select cell(C10) and replace with word 'fruit',if client 2(sheet2(cell(A3)) is italian (sheet2(cell(B3)) then select cell(A5) and replace with word 'orange',still select cell(C10) and replace with word 'vegetable'.Final print and save this range.
Could you give an example with code.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help to replace a word in word file (macro)	guwic	Word VBA	1	05-13-2019 12:23 AM
Word find and replace	ganesang	Word	4	11-27-2018 12:04 AM
In Find and Replace, can Word stop after each Replace?	wardw	Word	1	06-08-2017 02:47 PM
Need help using Find & Replace (MS Word)	BZee	Word	9	02-16-2015 05:45 PM
find&replace word in uppercase with word in lowercase	andrei	Word	3	10-03-2011 05:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:06 PM.