hange and every time a cell
is changed try to determine if the entry is complete. If true then
find where to copy it to and then insert the data in the other
worksheet.
if you
want to delete all sheets or just the cell contents. If cell contents
try something like
range(cells(x1,y1),cells(x2,y2)).clearcontents.
regards, lezley
On Jul 14, 8:58 am, bharghav r wrote:
> Hello all,
>
> 1> I need a code which hardcodes a cell value to the macro
> 2>
One more thing:
If you use variables and OnTime then never ever use the "End" command.
Rather make a goto to the end of the sub. If you end the macro with
"end" instead of "end sub" all variables will be deleted.
--~--~-~--~~~---~--~~
--
hat means if the call has already been made (but not
executed because another macros is currently active) the start of the
macro cannot be prevented (well, actually you can close the workbook
but that
one posted a macro that can actually take over
the communcation but critical event triggers are missing such as
OnComm. Not really a good solution.
Any help apprec
