Recent content by hopelessliar

OK, I see what you mean. Luckily for me, with the disparate data in this table, I don't think that's going to affect me and in fact, that's probably exactly the kind of behaviour I was looking for - I hope! And I'll slap myself for not looking in the obvious place for the info.

OK, first off, thanks for taking the time to reply. I've obviously midunderstood something here... Either I've described the problem badly or something's going wrong for me. It seems that whenever I add a new record to the database, it won't appear in any search results unless I manually...

I'm a real beginner with mysql/php but I've managed to put together a basic (1 table)mysql database and a web based search form which returns the relevant information. I've used a fulltext index (which includes most of the fields in the table) and this is what is now causing me some problems...

I've come up with the answer, it's actually really simple but for some reason my brain was refusing to see the easy answer! In case it helps anybody, this is how it's done: I used a variable called length length = Application.WorksheetFunction.CountA(Range("A:A")) so that gives you the number...

I think that it's normal for Outlook to show classic menus - there is no ribbon. As for the rss feeds, it works like this I think: you delete your subscriptions by going to: "Tools|Account Settings" and then the "rss feeds" tab. The folders will remain so that you don't lose any existing...

Hi all, I'm working on a sheet in excel and I've come up against a problem I can't seem to solve, any help would be gratefully received... Essentially, the sheet is 2 columns and what I want to do is move data from one column to another based on the value of the cell. I think I'm ok with...

Might be a bit of a longshot this... I have a 4D database file, and I have no idea how to manipulate it. Does anyone know if it is possible to convert the database to either access or mysql? Excuse my newbieness here, my only experience of databases is relativelt simple access and mysql...

Can anyone shed any light on this? When I add the circular reference icons to my toolbar, (View|Toolbar|customise|circular reference) they appear as required. BUT, as soon as I touch anything in the sheet, they disappear. I'm confused.

Thanks for all the help guys, Brad's function was exactly what I needed and Tony's thoughts may well prove useful at another time. Thanks again.

sadly not! I'm looking for a function that will return for example, "true" if the cell conatins a formula "false" if it is an input value

Does anyone know how to tell whether a cell is an inputted value or a formula? The spreadsheet I'm looking at predicts future values which should be replaced with final values by the user once the data is available. I want to be able to check whether the final values have been input. I'm not...

woo flipping hoo. Thanks Geoff, that is SO useful

you can do this using the text functions (left and length) in combination with a couple of IF statements. If you are unfamiliar with functions, write back and I'll be more explicit!

Could you maybe explain a bit more fully what you mean here - maybe it's just me but this doesn't seem clear...

I have a table that looks a bit like this: Jan Feb Mar Small red 1 2 5 Medium red 4 3 1 small blue 3 2 1 medium blue 2 4 1 Can I return the value at the intersection of the ranges 'Jan' and 'small red'...