Hello, this is a VBA query relating to Microsoft Excel 2007. I am trying to run a macro that copies the current sheet and deletes some of the content to provide a new blank sheet. Ideally I want this to use a value that is shown in a cell within the new sheet. Here it says Active Sheet because the moment you select the cell it becomes an active cell of the active sheet. So the code is “ActiveSheet.Paste” This is how the Paste method works in VBA. Formula. Below is the formula for VBA paste method: Expression.Paste (Destination, Link) An expression is nothing but what is the worksheet name you ...

Jul 01, 2013 · Because you are linking to a sheet that has a space in the name the hyperlink reference must be enclosed in single quotes. Also, you need to provide a cell reference for the link. See if this does what you want and if you need any more help please upload the file so we can see what you are copying and pasting and what results you expect to see. In order to check the name of a table go to Design >> Properties >> Table Name. You can use the previous VBA code, click on each of the tables, and run the code. But this time let’s create a code that will clear all filters from all tables in the worksheet.