I have a macro with the following procedure:
Set kopi = Range("A4:" & Range("K65536").End(xlUp).Address)
What I want to do is indicate the range not only to the laste row,but also to the last column.With other word the hole sheet set to make a copy.
Can somebody help?
Thanks in advance
Set kopi = Range("A4:" & Range("K65536").End(xlUp).Address)
What I want to do is indicate the range not only to the laste row,but also to the last column.With other word the hole sheet set to make a copy.
Can somebody help?
Thanks in advance