Why not record your actions and try to manipulate the code to loop
through the required number of cells. I looked at your file and do not
understand your logic for highlighting duplicate numbers as the numbers
you show you want highlighting are NOT the same?
xllearner;736061 Wrote:
Hi All,
I am new to the excel VBA. Your help is appreciated. Please Help me in
vba code for the following points.
I have attached the sample file of how i get and what changes would
required once after i run macro in the excel.
1) Sum to column.
2) If city code numbers are same then highlight the cell backgaround
color.
3) Merge the cell and highlight with the color.
Note: Data may vary. eg If today i am getting 100 tomorrrow it may
1000.
Regards
Praveen.
--
Simon Lloyd
Regards,
Simon Lloyd
'Microsoft Office Help' (
http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.thecodecage.com/forumz/member.php?u=1
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=206560
http://www.thecodecage.com/forumz