Anyone knows how to do that?
So anyone can try it for free for 7 days and can get the full activate
version after purchasing the key or it will stop functionning after 7 days.
Thanks.

How do you extract the time from a cell that has the function now() in it.  
For example I have a cell in a worksheet that might be hardcoded with the
time 14:30 and then I want to take the current time of the day and see if it
is greater than 14:30.  The problem I am having is ...

when a user changes the area of a selection (via a Ctrl+click), how do I
intercept this event and after that, how do I get to the selection object and
'read' what's in the selected parts (rows)? Thank you!

I am looking for a relatively safe and stable way for a user defined
function to return some data outside of the cell that called it.
Basically I have in cell A1 a function "=MyFunc()" and I would like it
to return in the cells:

Hi all, I have data in sheet (see below)
ROW     A           E        F-----col
1          3080     G16     11
2            500     G16     12

with my worksheet open, I want to pop up a non-modal dialog box such that
when I click within the worksheet the dialog stays on top anyways  (the click
changing focus to the worksheet but leaving the dialog visible on top); in
the worksheet there are simply rows of integers and ...

This is probably a very stupid question, but how can you change static
references into variables in Visual Basic code?
I have this:
Sub Test5()

Hi again
dose any one know how is possible to luck the cell automatically and
conditionally? i mean not by using the normal cell fomat option but forcing
the cell to be lucked when certain conditions meet?

I simply cannot get the Help example on FindNext to work.  Even explicitly
setting the find paramaeters still results in err 91.  The example cell value
is changed but then errors out at Loop While.
The problem seems to be with c.address.  What am I missing?

I found a web sit that I copyed the data off of so it could have my invoice
number update automaticaly.  I was wondering if thier was a way that it
wouldn't update untill I entered something into a specefic cell.  What I mean
is I don't want the invoice number to update untill I ...

I have a sheet where some cells have (quite long) formulas in them.
Sometimes, if the cells that they refer to are empty, the formula
cells will have #VALUE! and #N/A errors in them. I could use something
like =IF(ISERROR(formula),"",formula) to show a blank cell if there's

Hi, I have percentages table in Sheet1 (see below)
ROW    A         B ---col
1           GX      GT ---codes
2            %       %

I have following problem. I've created macro to make some calculations (and
simplify sheets) and I want to refer in this macro to other cell via
offset. How can I refer to cell well I've inputed this function, so I could
use Offset method.

Is it possible to declare a varible that can be seen (availble) from any
Sub(routine) within the current Module1?
If so How

I have a number of excel workbooks created from an export from our
accounting programme.
These contine all our invoice data for upload to our finace company
who then advance the invoice amounts direclty to us. This gives us