Assign active cell to a variable

Not sure what you're trying to do. Create a formula that has the link ? or assign to the ActiveCell the value of cellAddress ?

Option 1.

ActiveCell.Formula = "='" & MySheet.Name & "'!" & cellAddress

I'm assuming MySheet is a Worksheet and cellAddress is a String.

Option 2.

ActiveCell.Value = MySheet.Range(cellAddress)

Juan Pablo G.

I need help!! I work in a call centre and I have an excel spreadsheet that logs each call using a VB form - its just a simple table with 6 columns with text data - I want to put it on a network so that 10-15 users can update it at once. I don't think this is possible by sharing the one workbook 'cause when you go to save you get conflict problems. I reckon that if I make a copy of the workbook for every user this would be easier. The problem is I don't know how to copy (and then clear)the contents of each workbook from the individual worksheets to one main workbook which stores the data in seperate worksheets for seperate days. Does that make any sense? :-)
Any advise would be great

Melissa, post again, got messed up [NT]