I'm working on a macro to help me edit a report for me automatically. I
am trying to finish this macro up but hit a wall.

I am trying to use the networkdays function in order to create a "Days
since last login" column filled with data.

I have a column with "Last Login" filled with data but I don't know how
to populate a range of cells with today's date and then use the
networkdays function to fill in the "Days since last login". In the
end, the TODAY column would be hidden.

For example:
LASTLOGIN Today Days since last login
1/1/2007
12/30/2006
12/29/2006


Into : (note, days may not be correct)

LASTLOGIN Days since last login
1/1/2007 9
12/30/2006 11
12/29/2006 12


Since this is for a list that changes week to week in terms of cell
range, I didn't know how to have the program choose a range of cells to
select the "Today" column without going past the amount of data on the
left. And then choosing the next column to put in all the "Days Since
Last Login" cells that are needed.

__________________________________________________ ________________________________