Macro to store a table name as a variable

**odairtns** · 08-13-2012, 10:20 AM

Hi,
I have a workbook that is linked to different SharePoint sources and each one is stored in a different worksheet.
I have to create a formula that is based on a table row on all the sheets however, since the table name is different, the table name must change on all the sheets.
Is there a way for me to capture the table name as a variable so I can change it for the different worksheets?
On the following code I would like to change the table name “Table_owssvr_413” to the different tables on the worksheets.

Please Login or Register  to view this content.

Thanks!

**Bob Phillips** · 08-13-2012, 10:46 AM

Please Login or Register  to view this content.

**odairtns** · 08-13-2012, 04:35 PM

Thank you Bob!
It really helps me!!

**Jeff2886** · 10-29-2012, 04:46 PM

Originally Posted by Bob Phillips

Please Login or Register  to view this content.

I tried applying this method to my code and it doesn't seem to work if I remove the "For Each wSheet".

Is there a way to run this code without the loop?

Specific example:

Dim wSheet As Worksheet
Dim argh As String

Sheets("Sheet1").Activate
For Each wSheet In Worksheets
With wSheet
MsgBox .ListObjects(1).name
argh = .ListObjects(1).name
ActiveSheet.ListObjects(argh).Range.AutoFilter Field:=9, Criteria1:= _
"=New", Operator:=xlOr, Criteria2:="=Open"

End With

Next wSheet

End Sub

**odairtns** · 10-31-2012, 03:49 PM

You need to initiate the worksheet if you don't wanna use the loop.

Please Login or Register  to view this content.

Macro to store a table name as a variable

LinkBack

Thread Tools

Rate This Thread

Display

Macro to store a table name as a variable

Re: Macro to store a table name as a variable

Re: Macro to store a table name as a variable

Re: Macro to store a table name as a variable

Re: Macro to store a table name as a variable

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions