Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Returns the text in the active cell in the first window open on the workbook named Planning xls

Sub active()     MsgBox Workbooks("your.xls").Windows(1).ActiveCell.Text End Sub