Merging excel cells from VBA in access
Posted on 2004-10-29
I want to create a custom report in excel. I'm extracting the values of a recordset to the report.
I want to merge some cells but i can't because it doesn't work.
.cells(1,2).Merge true <----THIS DOESN'T WORK...WHY???
.range("A1","B1").merge true <---THIS WORKS...WHY???
How come the merge method works with range property and not with cells property?
I have to loop through the recordset and add records to each row below, and i can't do it like this either
.range("A & row & ","B & row & ").Merge true
row = row + 1