Can I use variables in the Sourcedata from a Dynamic Table??

How can i do this code works right, I need to use a variable

Act = InputBox("Today", "Now", Thisday) 'here i need to write: 10513 (sheet name)
Range("AA2").Select

This works OK

Please Login or Register  to view this content.

This dont...

Please Login or Register  to view this content.