Search results

Do you always refer to yourself in the third person ? KeithG wants to know where do you want the 'date stamp' to go ? or shoudl he just pick a cell at random ? HE knows how to access your sheet change event and when it gets fired for ANY change then he can write a new stamp to YOUR CELL, but...

What is the query ? SQL ? And the location and name of the mdb ? Is the mdb protected ?

He wants to know WHICH CELL ? or should he just pick one at random ?

Even if just open it then close it, Excel will warn you and give you the option to save as 'the current' file format. What version of Excel do you have ?

Yet another, 'drive by posting' ...

I assume that "a) Non Standard" is a valid folder and that each cell you wish to convert has a valid system file object in it then :- ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=ActiveCell.Value, TextToDisplay:=ActiveCell.Value Can be used as a single cell conversion You did not...

This has nothing to do with your mail client, it's your OS. Check the file properties under explorer in the tools, folder options, file types XLS, open should look like :- "E:\Program Files\Microsoft Office\Office10\EXCEL.EXE" /e It is possible for some installations to 'mess' with these. If it...

Scottie31, you are NEVER allowed to have a date / time field as a negative number. 13:00 - 14:00 would be negative so ... Do you just want hours or minutes as well ? Why would you ever want a negative time ?

He doesn't want them concatenating he just wants one list of both columns, Brians suggestion will work fine.

You didn't try very hard did you ? I did exactly as I suggested earlier and got this.

It's Data2 col A that are NOT numbers, try creating another column that =A2+0, drag down, then copy paste values into A again, delete temp column.

OK, If that's what he wanted the rosito's first reply would nearly have got him that, all he needed to do was trap the "not a number" bits. e.g. =if(isnumber(a1),if(a1=1,"A",if(a1=2,"B",if(a1=3,"C",if(a1=3,"D","Error !")))),"") or =if(isnumber(a1),mid("ABCD",find(a1,"1234"),1),"") Depending on...

Do you want me to send you back your list unfiltered ?

I opened your sheet and got down to row 1313 :- ALPHINGATE CLOSE Y Jan 2007 So I don't see your problem.

Okay I can see that ... (but why couldn't he say so ?) I admit I'm missing something then Brian, as I just can't see what the if's do for him. Which bit of my formula doesn't get him the values in every 4th row (that he said he wanted starting from row 1 ... to 5 to 9 to 13 ...) ? I see your...

Assuming apple is just flowery decoration and if's are irellevant and that the values are okay then :- (see attached for example =INDIRECT("Sheet1!A"&ROW()*4-3)) Alternatively I could do it with an array but that would slow your spreadsheet down ... alot ...

Eh ! You don't need the letters so why the if's and what about the other questions ? (apple and if just the value list is ok ?)

Are you sure you have removed ALL criteria from the filter to look at ALL records ? If so post the workbook and we'll pull it apart and find out what went wrong.

Do you see the little "?" symbols ?

Why'd you do this twice ? Why'd you do this twice ?