Thread: Application.Caller
View Single Post
 
Old 03-18-2009, 11:48 AM
pankajkankaria pankajkankaria is offline
Novice
  
Join Date: Mar 2009
Posts: 2
pankajkankaria is on a distinguished road
Red face Application.Caller
Hi

This is a complicated issue made simple.
I use a function call in Cell 'C7'. Everytime I invoke the function, I want the cell value of E7 to have the current [date] & [time].
I then copy the contents of Row 7 to Row 8 and teh row 7 is used again for the function call.

How can I achieve it through VBA.

Regards
Pankaj
Last edited by pankajkankaria; 03-18-2009 at 11:52 AM. Reason: Typo
Reply With Quote