Hi,
So I've created some code that will copy and paste data from one worksheet in one workbook to another new worksheet that I have to create. Is there any way to automatically keep the textsize, column spacings, row spacings etc from the data that was copied?
Also the way that i am copying is using the workbook.worksheet.range.copy code, is there any way to not have to use the range and just copy the entire sheet in it's entirety? This would alleviate the issue I think, but I have failed to find the proper coding.
thanks.
So I've created some code that will copy and paste data from one worksheet in one workbook to another new worksheet that I have to create. Is there any way to automatically keep the textsize, column spacings, row spacings etc from the data that was copied?
Also the way that i am copying is using the workbook.worksheet.range.copy code, is there any way to not have to use the range and just copy the entire sheet in it's entirety? This would alleviate the issue I think, but I have failed to find the proper coding.
thanks.