[cells] Forum Topics

I'm still having a problem with this. Can someone help? Let me explain a little more of what I need. Range("G3:G" & Cells(65536, "A").End(xlUp).Row).Select Selection.FormulaR1C1 = _ "=IF(ISNA(VLOOKUP(RC[-6],SUMMARY2!C[-6]:C,7,0)),35,VLOOKUP(RC[-6],SUMMARY2!C[-6]:C,7,0))" Sub Compare() Worksheets("SUMMARY2").Visible = True I'm still having a problem with this. Can someone help? Let me explain a little more of …

URGENT: guys i really need your help with this. I have been debugging my program for days but it doesn't seem to be improving this is the code for the table layout: <table border="1" id="COT_Table" onclick="getTableID(this)"> <td rowspan="3" scope="row">COT</td> <th colspan="4" scope="col">SFAL</th> </tr> <tr> <td colspan="2" scope="col">Temperature</td> <td rowspan="2" scope="row">vol …

i created a report which exports to excel. it exports just fine. what i want to do now is merge the consecutive cells in a column which have the same values. how do i do this? please help me. this is code that generates the excel body: Protected Sub generateExcelBody(ByVal …