Hi,

Am Tue, 5 Jun 2012 11:02:15 +0000 schrieb BrkenRecord:

That would work except I need the 'i' value to be variable, so i need to
get the ActiveCell command to work for me. Any thoughts?

then try it this way:

Sub GetTableValue()
Sheets("TableC11").Select
i = ActiveCell
MsgBox "value is " & i
End Sub


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2