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...

How clever's that! Thanks - i can see a number of applications for that logic in some other spreadsheets that i can now streamline. Fair comment re the hang-over from days-gone-by but i guess one step at a time for us dinosaur accountants. cheers Matti

Again, obvious when shown. i'd been looking at this problem so long my brain had gone off for a brief vacation. I appreciate the bottom up logic..however.. i have subtotals in column d which now get deleted first. it's certainly a more elegant solution than the 'Select' macro so i'd rather use...

Thanks Stewart for your time and Thanks Tony...gee it's obvious when somebody points it out. the first fix..with the the extra line to get me back to column d works a charm thanks. the second is beyond me..what on earth is it doing? it demonstrably works..from the bottom up.. but i can't see why...

Gee if this isn't the most frustrating bit of code. It's broken down at the first line of; strLeft = ActiveCell.Offset(0, -4).Address .. mind you it could be giving my street address and i couldn't see the problem i've been looking at the damn thing so long Matti

Thanks again Stewart...still no result. I've never actually selected a range of cells using Range.Select, only individual references. I'm presuming it's the right command - it is isn't it? Matti

Thanks Stewart..but..still no joy. The macro still pulls up at this point. Are the quotation marks correct in your code? Matti

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...

I've got around this problem by defining the number of times to loop using; i=75 at the start and; i = i + 1 before the loop it isn't exactly what I was after - but essentially I wanted to control how far the macro ran into the spreadsheet - so ... the result is what counts! Thanks PH for...

Thanks PH but that hasn't improved matters. Is there more to the Do Until and Loop commands that i have missed?

Hooray - that works a treat ... no idea why mind but works a treat thanks. now the bit i thought worked doesn't - could i impose a little further? the 'do until..' line is a problem. i've looked at this problem so long now i wouldn't see the answer if it bit me on the nose. Range("d4").Select...

Thanks for the answer PH but have given that a go and still no joy. I have stripped a spreadsheet right down to just a few rows and have used the =error.type(a1) formula to ensure that the cell i'm interrogating is in fact returning error type 7 - aaaaaghhhh

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...