Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identify row based on criteria and copy paste special values only
I've got the following code that does select the correct row and bolds
it, but it's not doing the copy and paste special.....can anyone help me out on this? For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row If Cells(i, 7) = "" Then Rows(i).Select Selection.Font.Bold = True Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End If Next i |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy - Paste Special (Values) | Excel Programming | |||
Copy & Paste Special Using Values | Excel Programming | |||
copy paste special values | Excel Programming | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming | |||
Complex identify values then cut/copy/paste query | Excel Programming |