-
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.
replacement=
-
J
if match found delete from Multiple sheets |excel|VBA|
Sheet 0 : https://paste.pics/82a491cbc642d6fff555ef70612aec5b Sheet 1 : https://paste.pics/cafe8628b76e56789cf03b06a923bde8 Sheet 2 : https://paste.pics/2320369d395a22c868b5e439b456ad3a Sheet 3 : https://paste.pics/9fc84c7f43e1a2819d1537593c44c1f9 If match is found => "SUP" "AL" "AP" then Data...- jackbhai
- Thread
- excel replacement= sheet vba vba & excel
- Replies: 8
- Forum: Excel Questions
-
J
Change my sheets
Trying a little humor with the subject. :) I recorded the following macro in excel, then shortened/simplified it. If I am in Developer Mode and run it from there, it works great, but.. I am trying to assign the code to a button. When I do and click the button, it appears to be running on...- juneau730
- Thread
- lookat=xlpart m/d/yyyy replacement= selection.numberformat
- Replies: 11
- Forum: Excel Questions
-
S
VBA Replace number with ""
Is there a way to replace numbers with blanks. Example: .replace what:="number", replacement:="" I want to replace all numbers.... Thanks!- sachavez
- Thread
- .replace numbers replace replacement= what=number
- Replies: 7
- Forum: Excel Questions
-
D
Replacing Special Characters Macro
Hello! I know I am probably making a very basic mistake that my brain just isn't picking up on. I am writing a simple macro to replace special characters in a column (,.?#, etc.). This has to be used in several different sheets and the columns will vary. So I have the following code...- DragonTamer
- Thread
- cells.replace lookat=xlpart matchcase=false replacement= searchorder=
- Replies: 2
- Forum: Excel Questions
-
B
Replace VBA
Ia a way to combine the following two codes. i.e. Replace "th" or "rd" with "" <colgroup><col width="72" style="width:54pt"></colgroup><tbody> Selection.Replace What:="th", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True...- billandrew
- Thread
- lookat=xlpart matchcase=true replacement= searchorder=xlbyrows selection.replace
- Replies: 2
- Forum: Excel Questions
-
J
VBA - Remove numbers from column
Hello, This code removes the "/" from all cells in a column, how would I adapt to remove numbers please? Sheets("Sheet3").Columns("B:B").Replace What:="/", Replacement:="", LookAt:=xlPart- jamescooper
- Thread
- adapt column numbers remove replacement=
- Replies: 4
- Forum: Excel Questions
-
Remove front Value ( EG : Status = ) and make it a Header Name
Gurus I have a data from Column A to Column BB. The data can go up till 500,000 lines or more. I have record a macro for the changes that I've done. The macro works pretty well but it run really slow which I believes due to it has a lot of redundant code that can be simplify to make it faster...- Vgabond
- Thread
- activecell.formular1c1 activewindow.scrollrow replacement= selection.delete shift=xltoleft
- Replies: 4
- Forum: Excel Questions
-
D
Need Macro to Carry To The Last Line in Sheet
Below is the Macro I am using, but currently it only carries down to row 12. Can someone please help me modify so the Macro carries to last last line of data in the sheet. I will be using on multiple sheets in the future, so the row count may vary. Sub Byers()' ' Byers Macro ' ' Keyboard...- DCBUS
- Thread
- lookat=xlpart macro matchcase=false replacement= searchorder=xlbyrows
- Replies: 7
- Forum: Excel Questions
