.colorindex

I am running the macro below automatically at opening the workbook so It always looks the same. But when I delete the hyperlinks it changes the cell color if a hyperlink was there. Doing so manually via the mouse does not. I would like to preserve the cell colors. any ideas...

Hello, I would like the code below to then be merged between cells A:D. Cells(lastrow, 1).Offset(8, 0).Select With Selection .Value = "Account Holder Signature" .HorizontalAlignment = xlCenter End With With Selection.Borders(xlEdgeTop) .LineStyle =...

Hi, trying to combine these two codes to work simultaneously. can anyone help as the second macro works as opposed to both. First Macro: Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String Dim Newvalue As String Application.EnableEvents = True On Error GoTo Exitsub If...

Hello, I am trying to create a dynamic worksheet name in my dynamic range borders macro. I got the range borders to be dynamic but now I am struggling with creating a dynamic worksheet name that I do not have to change for each report I run. This is the code I have: Sub DynamicRangeBorders()...

I'm a total noob at vba, so forgive me if this is a simple fix. Last time I were here, I got some nice person to help me with this: Sub ToggleGrey() Dim ChkBox As Excel.CheckBox Set ChkBox = ActiveSheet.CheckBoxes(Application.Caller) With Range(ChkBox.LinkedCell).Offset(0...

Hi, I would like to add borders to all cells within the range of columns U:AE, starting from row 5, all the way down to the row where column B is still populated with data. Columns U:AE will at times be blank, hence I need to reference another column that will always have data in. Finally...

In the 'red'code below , if the user chooses N, I need it to go to the 'green' code bit at the bottom just before the 'exit' so the cursor ends up in cell A2 & a msgbox dispalys to prompt the user with a message of advise. It works fine if Y is chosen? Sub importdata() ' ' importdata Macro...

Hello I have developed a VBA macro for multiple sheets in a workbook that clears out previous Data, grabs a Txt file from another location then copies and pastes the data from the text file into the specific worksheet as the new data. I have gotten the macro to work for all the worksheets...