VBA To Insert Page Breaks

[J. Trucking]

Hello,

I have a spreadsheet in which some of the cells in column a are
merged. Column A represents an employee name and the columns beside
it represent different data. What I would like to do is insert a
horizontal page break after each employee name all the way to the end
of the data. Does anyone know how to do this? Because the cells in
Column A are merged, can I just create a loop and make a break after
each "row"?

Thanks in advance,

John

 

[Héctor Miguel]

hi, John !

I have a spreadsheet in which some of the cells in column a are merged.
Column A represents an employee name and the columns beside it represent different data.
What I would like to do is insert a horizontal page break after each employee name all the way to the end of the data.
Does anyone know how to do this?
Because the cells in Column A are merged, can I just create a loop and make a break after each "row"?

*IF* cells in column A are merged in several (and distinct) number of rows...
AFAIK merged cells could be a PITA (even for code, not to say for a "simple" navigation thru your worksheet)

you could do looping *IF* you tell the code how many rows are between each (merged) "row"

hth,
hector.