Search results for query: *

I am trying to write a Crystal report which allows me to specify a parameter 01 to 12 which indicates month i.e. Jul - Jun. The parameter is to substitute for the last two digits within a report field e.g. auglmlbal.act_p04 i just can't seem to get it right!

When using multiple workbooks in excel when swapping between workbooks in the "Windows" drop down menu it only shows 9 workbooks. Is there any way of expanding the size of the box to show more? I am using 12 workbooks concurrently and it is driving me mad having to go to ..more windows and then...

I am continuing to struggle with a macro that should be a piece of cake. It is supposed to scan down thru a spreadsheet removing parts of rows that have returned #N/A in response to vlookup. I can't select the entire row as there is detail further to the right. The macro to date is...

Am trying to delete rows from a spreadsheet where vlookup has left #N/A as the result. There are a couple of good threads as to how to get vlookup to give a different answer - but given that the error.type for #N/A = 7 there really should be some easy way to make this formula work. I have tried...