VBA MACRO Paste table to Print

[THEVULGRIM]

Hey guys its me again bothering you all


So trying to figure out some stuff, so far being great actually. So got a bit stuck haha


The thing got stuck was making the code only work if something is being filtered, if not is being filtered the code does nothing. And having few issue when the table is pasted printing is not printing the table correctly.

the table to be printed is sheet "TESTPASTE"

Please Login or Register  to view this content.

Test file added.

[THEVULGRIM]

Please Login or Register  to view this content.

got the first part fixed, just need helping with prinout the sheet "TESTPASTE"

[THEVULGRIM]

[QUOTE=THEVULGRIM;5676203]

Please Login or Register  to view this content.

Actually it did not fix anything,

Any help ? For example let assume there is no data for tomorrow and i pick "2" the header shouldnt appear which is row 3.