Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I format the last row !
I am using Excel2002sp3 on WinXP. I have written
Worksheets("Report(metArb)").Activate Range("B3").Select Selection.End(xlDown).Select lastfilledrow = ActiveCell.Row ActiveSheet.Cells(lastfilledrow + 2, 5).Value = "Totaal" sumcellformula = "=sum(h2:h" & lastfilledrow & ")" ActiveSheet.Cells(lastfilledrow + 2, 8).Formula = sumcellformula sumcellformula = "=sum(i2:i" & lastfilledrow & ")" ActiveSheet.Cells(lastfilledrow + 2, 9).Formula = sumcellformula sumcellformula = "=sum(j2:j" & lastfilledrow & ")" End Sub to find the last row and make some totals. This seems to work okay, but I am having trouble selecting the lastfilledrow+2 ... that is selecting the whole row. I'm sure it is simple, but I can't for the love of me figure out how to do it. Basically .... how can I format the lastfilledrow+2, columns 5 to 9, so that they are bold and red.... or basically how can I select the whole or part of a row so I can format it ? thanks for your help ... Roger |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming |