Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I seem to be having brain lock and cannot figure out how to add additional
formatting to the code. Code below. I'm looking for cells that contain markers and copying to a new worksheet. I'm retaining the value of the cells and also would like to format the cells with the "" marker as bold and LeftJustified. Your suggestions would be greatly appreciated. Dave Sheets("Items").Activate ktr = 8 Set percrange = Range(Cells(1, 1), Cells(150, 1)) For Each thing In percrange If IsNumeric(thing) And (thing 0) Or (thing = "") Or (thing = "") Then ktr = ktr + 1 currrow = thing.Row Range(Cells(currrow, 1), Cells(currrow, 9)).Select Range(Cells(currrow, 1), Cells(currrow, 9)).Copy Sheets("Order").Activate Range(Cells(ktr, 1), Cells(ktr, 9)).PasteSpecial (xlPasteValues) Sheets("Items").Activate End If Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting (Dates) Repost with additional data | Excel Discussion (Misc queries) | |||
Additional Conditions for Conditional Formatting | Excel Worksheet Functions | |||
AUTO FORMATTING WHEN ADDING ADDITIONAL ROWS | Excel Programming | |||
Excel: Additional Conditional Formatting | Excel Worksheet Functions | |||
additional help | Excel Programming |