.pattern

Hello, I'm looking for help in locating and replacing/deleting the following pattern within a string in a cell: "xxx.xxxxx.xxx.xxxxx.xxxxxxxxxxx" where x represents a numerical character i just learned how to use regExp...but can't figure out for the life of me how to tell it to look for the...

I am trying to run a macro to edit a table's formatting including table totals. Some tables do not have table totals and this is creating an error. How do I insert an is error inside my code? Range("A2").Select ActiveSheet.ListObjects("Table1").TableStyle = "TableStyleMedium8"...

hi This works: Sub startbox() Dim i As Long n = InputBox(" Where Should the Fill Color Start?") x = InputBox(" How many times to run?") Range("B" & n).Select For i = 1 To x With Range("A1:I1").Interior .Pattern = xlSolid...

Hello, Please let me know how to include these characters ( " " , []) also in the following pattern .Pattern = "[{}+=<>?'_~`!#$%^*]"

I have text in B1 = : 2 myrext: take and :test In c1 = 2 d1 = take ,e1 =test This is my pattern .pattern ="^[:]([^:].+?\s)$" What wrong with my pattern in regular exspresion

I need to change the fill color for a column of cells based on RBG values. For example: <tbody> R/C A B C D 1 R G B Color 2 255 0 0 3 0 255 0 4 0 0 255 5 85 170 255 </tbody> In D2:D5, I'd like to set the fill color based on the RGB values in the cells in A:C of that row. I...