Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
jlgwhiz or mike H helped me out with this awhile ago. Well, for lack of a
better excuse I lost some data and had to start over. Now I cannot get this to work and cannot figure out why. I am getting a variable not defined error. Sub ConcatColor() lastRow = Cells(Rows.Count, 1).End(xlUp).Row For i = 2 To lastRow '<<assumes header row If range("P" & i).Interior.ColorIndex = 3 Then range("P" & i) = Cells(i, 7) & Cells(i, 8) & Cells(i, 9) End If Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum working days | Excel Worksheet Functions | |||
Calculate working days but change working week | Excel Discussion (Misc queries) | |||
Making weekend days working days - the system cuts the working tim | Excel Discussion (Misc queries) | |||
How to calculation no. of days (only working days) between two dat | Excel Discussion (Misc queries) | |||
Working Days | Excel Programming |