Search results

i want to find the number of merged blocks in column 1 before I encounter a text(report) in that column 1 . can any one please help me

I have in my first column merged cells and from second column i have unmerged columns . i want to color entire rows of alternate merged cells along with all the unmerged columns corresponding to those merged cells .

Hi , I have to find a text in the sheet and from that cell i have to merge 6 cells horizontally . I am not good at VBA . i need help please i have written a code for finding the text Set cell = ActiveSheet.Cells.Find(What:="~ ~ Enquiries", After:=[A1], LookIn:=xlFormulas, LookAt:=xlPart...

Can anyone help me I saw the HW of Chandoo for the above problem which creates a helper column etc etc , but my table has merged rows , the above table is not the way it is week method enquiries ----------------------------- week1 email 5 coupon 10...

Hi Hui and Raviaroa, Thank youfor your suggestions and it is a great help for me.

i have a table like this week Numbers week1 123 234 123 week2 456 234 123 i want to conditional format this table week1 is merged cells. The number of merged cells is dependent on the number of rows on its right and may vary every week . I want to give a color to every alternate...

I create a workbook1 and a macro for a sheet1 in it . Later i create another workbook2 witha sheet1 . Now i want to use the macro of workbook1 on workbook2 sheet1 . how can i do that

I have a sheet name summary in the workbook where i maintain the summarised data of all the sheets in each row . example students noofdownloads noofprints week1 123 234 week2 345 254 when a new sheet is added to the workbook , the summary sheet should have another...