The macr pastes in the next open cell after F150 if F150 has a value (same thing with G150). When I have rows 100 through 200 height set to 0 to hide those rows, it paste these in other cells in column F and column G. What can I do. It works fine when the rows are not hidden.

HTML Code: