.linestyle

I use Range("A7", "N" & lastrow).Select Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous .ColorIndex = 0 .TintAndShade = 0 .Weight =...

Hi Guys, I'm trying to apply conditional formatting on a script I've recorded for data exported from another program. So the conditional formatting I'm trying to apply is to color values between 70%-89% yellow and 90%-100% red. When applying these conditions the entire row is highlighted...

hi, this is my current code: ' ' importdata Macro ''workbooks("lap_lookup.xlsm").sheets("info").unProtect Workbooks.Open Filename:="C:\123\123_data.xlsx" Range("A2:H3007").Select Selection.Copy Windows("123_lookup.xlsm").Activate Range("A2").Select ActiveSheet.Paste...

I need to paste Format conditional formatting to every 6th row with the starting range ("I22:AM22") This has to continue until the equivalent range (every 6th row) in cell "A22" is blank Thanks for any help! Range("I22:AM22").Select Range("I22").Activate Selection.FormatConditions.Add...

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

How do I make this all in 12 lines? I don't think it is possible without adding the with selections Range("A1").Select With Selection.Font .Size = 36 End With With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With With...

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

Hi all, I'm not sure if anyone will be able to help me, I have a report that has a random amount of lines where I am using VBA code to format it in the way I need. This issue is that some of the formatting code stops at row 2501 and I am not able to see why - the code I have is below...

Hello Everyone, I would imagine this to be a very easy fix for the skilled members of this forum, but I personally do not know how to do so. I created the following simple macro that applies border lines to select cells. It adds a border around the edges, as well as adds border lines to...

Hello everyone on MrExcel, I thank in advance anyone that will help me resolve my problem. At work my collegue uses the below Macro to extract data from an Excel generated by a program (HP Quality Center, in postprocessing). For some reason, the Macro works for him but not for me. He uses Excel...