Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Formatting issue....
I'm trying to get only certain cells to BOLD, but am running int
problems. So far, I have the following: Application.Run "'Part D-1 Regular.xls'!Unprotect_Sheet_Password" Sheets("April").Select If Range("O17") = "Bold" Then Range("C17").Select Selection.Font.Bold = True ElseIf Range("O18") = "Bold" Then Range("C18").Select Selection.Font.Bold = True ElseIf Range("O19") = "Bold" Then Range("C19").Select Selection.Font.Bold = True ElseIf Range("O20") = "Bold" Then Range("C20").Select Selection.Font.Bold = True Else MsgBox "No Other Payor Sources to be Bold!" End If End Sub If cell O18 doesn't say "BOLD" the script stops even if cell O19 doe say "BOLD" This is driving me crazy, I've also tried changing "ElseIf" to jus "If" but it still runs into the same problem. what am i doing wrong -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Formatting issue....
If Range("O17").Value = "Bold" Then
Apply that change to each IF statement. - Piku -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Formatting issue....
Hi
try the following: sub foo() dim row_index as long Application.Run "'Part D-1 Regular.xls'!Unprotect_Sheet_Password" for row_index = 17 to 20 with activesheet.cells(row_index,"O") if .value = "Bold" then .offset(0,-12).font.bold=true end if end with next End Sub -- Regards Frank Kabel Frankfurt, Germany I'm trying to get only certain cells to BOLD, but am running into problems. So far, I have the following: Application.Run "'Part D-1 Regular.xls'!Unprotect_Sheet_Password" Sheets("April").Select If Range("O17") = "Bold" Then Range("C17").Select Selection.Font.Bold = True ElseIf Range("O18") = "Bold" Then Range("C18").Select Selection.Font.Bold = True ElseIf Range("O19") = "Bold" Then Range("C19").Select Selection.Font.Bold = True ElseIf Range("O20") = "Bold" Then Range("C20").Select Selection.Font.Bold = True Else MsgBox "No Other Payor Sources to be Bold!" End If End Sub If cell O18 doesn't say "BOLD" the script stops even if cell O19 does say "BOLD" This is driving me crazy, I've also tried changing "ElseIf" to just "If" but it still runs into the same problem. what am i doing wrong? --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Formatting issue....
i've tried
If Range("O17").Value = "Bold" Then but it still stops @ cell C18 (the cell w/o "Bold") -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Formatting issue....
Do you realize that using If...ElseIf means that the code will sto
after the first time that condition evaluates to true? You could d something like this: For x = 17 To 20 If Worksheets("April").Cells(x, 15).Value = "BOLD" Then Worksheets("April").Cells(x, 3).Font.Bold = True End If Next x - Piku -- Message posted from http://www.ExcelForum.com |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Formatting issue....
this works, but I need to go all the way to row 174
-- Message posted from http://www.ExcelForum.com |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Formatting issue....
For x = 17 To 174
If Worksheets("April").Cells(x, 15).Value = "BOLD" Then Worksheets("April").Cells(x, 3).Font.Bold = True End If Next -- Message posted from http://www.ExcelForum.com |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Formatting issue....
I also need to use this for May through March (the 11 other worksheets)
How would I go about implementing this change -- Message posted from http://www.ExcelForum.com |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Formatting issue....
Hi
missd that part :-) Though you could also use then: sub foo() dim row_index as long Application.Run "'Part D-1 Regular.xls'!Unprotect_Sheet_Password" for row_index = 17 to 200 with activesheet.cells(row_index,"O") if .value = "Bold" then .offset(0,-12).font.bold=true exit for end if end with next End Sub -- Regards Frank Kabel Frankfurt, Germany Do you realize that using If...ElseIf means that the code will stop after the first time that condition evaluates to true? You could do something like this: For x = 17 To 20 If Worksheets("April").Cells(x, 15).Value = "BOLD" Then Worksheets("April").Cells(x, 3).Font.Bold = True End If Next x - Pikus --- Message posted from http://www.ExcelForum.com/ |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Formatting issue....
For z = 1 To 12
For x = 17 To 174 If Worksheets(MonthName(z)).Cells(x, 15).Value = "BOLD" Then Worksheets(MonthName(z)).Cells(x, 3).Font.Bold = True End If Next x Next -- Message posted from http://www.ExcelForum.com |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Formatting issue....
This is better...
Application.ScreenUpdating = False For z = 1 To 12 With Worksheets(MonthName(z)) For x = 17 To 174 If .Cells(x, 15).Value = "BOLD" Then .Cells(x, 3).Font.Bold = True End If Next x End With Next z Application.ScreenUpdating = True That should be a bit faster. - Piku -- Message posted from http://www.ExcelForum.com |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Formatting issue....
|
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Formatting issue....
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting issue | Excel Discussion (Misc queries) | |||
Formatting Issue | Excel Discussion (Misc queries) | |||
CSV formatting issue | Excel Discussion (Misc queries) | |||
formatting issue? | Excel Discussion (Misc queries) | |||
Formatting issue | Excel Worksheet Functions |