matchcase=true

Can anyone help with this please: I wish to Find any cells in Rows(1) with the value "To Attribs". Then for each column with this heading, for each cell, to replace specific strings with "" (i.e. delete the strings). In case it is relevant, some of the cells in the columns with the "To...

Hi, I am trying to tweak this code so that instead of manually typing in the code the new month in MM format every new month I can just reference the value in cell K1 that updates on its own. Is there a way that I can replace the month replacement value "/01/" with the data that is in cell K1...

I am currently use code like the one below to assign column numbers based on the column header title. Unfortunately there can be 30+ headings which takes some time to write code for, I was wondering if there was a quicker way of doing this or if possible shorten the code i already use? Any help...

Hi everyone, I'm just starting up with VBA to get rid of some manual work I have to usually do. I have to group certain rows in sheets, in this case it would be anything between ranges 1 and 2, 2 and 3, 3 and 4 for each sheet. "Total Revenues Post RMC" and so on are constant for every sheet...

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...