How can you when using vlookup return a value of 0 rather than #N/A when the
lookup value is not present in the table array?
Thanks
Nick

Can someone show me how to check if the delete key has been pressed?
Thanks,
Bernie

I have to compare 2 lists of numbers every month and find the difference
between them

I have a spreadsheet containing charts that are linked to cell range
within the worksheet. (last four weeks of data).
Every week, we must go in and move the source forward one colum
manually.

How can I get back the key of collection object?
Best regards
Gabriel

I have a column with numbers in them with a leading blank, like below.
 '5179455010055341
I want to copy them to another column and have them formatted like below:
5179 4550 1005 5341

I have a problem with selecting first cel in selection Range or return
an index of the first cell in Selection Cell.
I have something like this:
...................

I'd like to write a code to dynamically resize the worksheet screen based on
the selected worksheet. For instance, if a user selects "worksheet1" then
size to 640x480 and if it's worksheet2 then size it to 1024x768.
Thanks

Hi, if Ive assigned values from a1:a20 in vba to 'myarray', and I want
to delete the first row/value so value 2 now becomes 1 etc, what is the
best way to do this.
Regards Robert

   I updated my system fron Window's 2000 Pro to Window's 2003 XP
Professionnal
Most of my vba programmation doesn't work well on 2003 XP  and messages like
"Project or lybrary not found" appears for very basic functions like ;

Hi, if  name a1:a20 as 'myvalues' then in vba assign to an array
'myarray', how can I check 'myarray' to see if it contains any values
using vba. Or even check 'myvalues'. Either would do.
Regards Robert

I have created a timesheet that has 2 command buttons, 1 transfers dat
to a data sheet and the other clears the timesheet, but when I pu
protect sheet the VBA button won't work, what am I doing wrong???
--

Hello, I have an excel program and want to give the user a method to simply
stop using the file, and close it without "saving" any of the data. Can
anyone tell me what code to use?
Thanks in advance

an Shout out to all Excel Wizards!!
My Problem, take populated cells from column A of sheet 1 and search
and copy rows from sheet 2 that match the certain of column E, and
paste full rows to sheet3 until all cells in sheet 1 have been used up.

I am trying to extract and list out the conditional list on other
worksheet from the main worksheet, I am trying all the options but I am
not able to extract multiple rows, can anyone please help me on, it
will be a great help.