I tested your main macro "update" it works alright without any interruption.You have written the macro correctly. in my computer this code
.TintAndShade = 0
gives me error. (I ignore it). I do not see the need for it when color index itself is 0.
now you say that some formats are not reflected when the combined macro is run. can you give five examples
1) the code where you have made this
2)what cells should have what format
when you copy and paste why do you say "xlpastevalues" are they formulas then only this is required.
besides only if some format is there in source it can copy any format. if there is no such format there is no format to copy
if you just pastespecial xlpasteall
this would be enough to paste the cells as it is including color format of source cell if any.
the macros need to be tweaked a lot. there are repetitions
one e.g
Sub pendinglist_maint()
Dim r As Range, c As Range, k As Integer, m As Integer, n As Integer
With Worksheets("PENDING-MAINT")
.Rows.Delete
.Cells.Clear
End With
when you delete the rows what is the need for cells.clear.
cells.clear would be enough.
besides you must also tell what you what you want to do step by step
the macros are OK as they are though needs lot of tweaking
post comments and feedback .
The code is as follows
sub "macro name"
call "macro1"
call "macro2"
call "macro3"
end sub
One more point sir, when i am running 4th macro i.e combining 1 to 3 macros, data is correctly transferred to the respective sheets but only formatting part is not coming correctly.
with regards
kishore