Thread: Replace word
View Single Post
 
Old 11-23-2019, 10:39 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Here's part of it; I imagine you can adapt it to your own coding style and expand from German to Italian:

Code:
Set owb = ThisWorkbook
Set ows1 = owb.Worksheets(1)
Set ows2 = owb.Worksheets(2)
if ows2.Cells(2, 2).Value = "german" Then
  ows1.Cells(5, 1).Value = "apple"
  ows1.Cells(10, 3).Value = "fruit"
  End If
Not sure what you mean by "save range", and I never print so I'll have to leave you to figure out that part.
Reply With Quote