Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Write a macro to change formulas Write a macro to change formulas
Register FAQ

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 04-20-2016, 06:11 PM
Xyz_999 Xyz_999 is offline Write a macro to change formulas Windows 10 Write a macro to change formulas Office 2016
Novice
Write a macro to change formulas 		 
Join Date: Apr 2016
Posts: 4
Xyz_999 is on a distinguished road
Default Write a macro to change formulas
Write a macro to change formulas
I have an excel Sheet1 and has formulas in column A. Some of these formulas refer to Sheet2 such as +Sheet2!A1, +Sheet2!A100, +Sheet2!578, .... I would like to find all these references and remove from the formulas in Sheet1 so it never refers to Sheet2. How can I do this, this needs to be done in all the rows in Column A, if this needs to be done in a macro what type of macro that can achieve this?
  #2  
Old 04-20-2016, 10:30 PM
macropod's Avatar
macropod macropod is offline Write a macro to change formulas Windows 7 64bit Write a macro to change formulas Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
You could do this using Find/Replace. No macros required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
  #3  
Old 04-20-2016, 10:40 PM
macropod's Avatar
macropod macropod is offline Write a macro to change formulas Windows 7 64bit Write a macro to change formulas Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
I see you have posted this question twice. Kindly don't do that.

Thread closed.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Closed Thread

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Write a macro to change formulas Write a macro to change formulas Xyz_999 Excel 1 04-20-2016 09:51 PM
Write a macro to change formulas How to change this printing macro terrymac Excel Programming 1 12-01-2015 06:47 PM
write need help and copy write need help on another page auto wykoems Word 2 07-25-2013 07:56 AM
How do you write a macro with an IF Function Scheuerman1987 Excel 5 06-05-2013 06:04 AM
Write a macro to change formulas How to write a macro to find a specified name in a list of data? Jaffa Excel 1 10-23-2010 02:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:36 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft