-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
rplc
-
S
Using VBA Replace Function to Edit Formulas
I'm trying to create a loop to Find and Replace parts of formulas on my sheet labeled Output. With my current code, the replace function isn't working and I suspect it's trying to replace string functions only. I need this to alter the formulas. For example here is my array on Sheet1 with column...- smit3446
- Thread
- calc dim fnd replace rplc
- Replies: 1
- Forum: Excel Questions
-
K
Date not showing after paste
I have a report file, in some section i am copying a table from a remote computer into local excel file, but after copy date's are not like date, i need to search & replace everytime ( search "." replace with "." )then dates comes. I have a vba code but not correcting in all sheets. Sub...- konficus
- Thread
- date dates dim replace rplc
- Replies: 4
- Forum: Excel Questions
-
R
VBA Userform - Find & Replace
Found this code to Find and Replace; Sub FindReplaceAll() 'PURPOSE: Find & Replace text/values throughout entire workbook 'SOURCE: www.TheSpreadsheetGuru.com Dim sht As Worksheet Dim fnd As Variant Dim rplc As Variant fnd = "April" rplc = "May" For Each sht In ActiveWorkbook.Worksheets...- Robby19
- Thread
- dim find rplc sht variant
- Replies: 8
- Forum: Excel Questions
