Help would be appreciated, I'm new to world of Excel macro writing.

I wrote a macro in which I used 'Range' as follows
Windows("A v F Tables.xls").Activate
Period = Period + 53
MyColumn = Range("B" & Period)
[This successfully identified a value within the file stated.)

However, when I created a menu worksheet, inserted a ActiveX command button, allocating the mocro to it, and ran it, it failed to return a value for MyColumn.

I think I'm making a silly stupid error with the addressing of range, but can't see it.

Any help would be appreciated.

PS Before doing this I did move the macro from Module1 to Microsoft Excel Objects - Sheet1