Recent content by groovygarden

Thanks all. Another possible option - how about if I bought a cheap Express slot graphics card with TV Out & an s-video connection? Would that let me connect to a TV? Something like...

Thanks. I was hoping for a nice, cheap solution like that! The product details do say though that "This adapter works with graphics cards that have TV-Out function capability through the VGA connector. Check your Video Card manual or manufacturer to make sure that your VGA card has TV-Out...

Hi all, I (stupidly?) ordered a Dell Vostro 1510 last week, and it's due to arrive tomorrow. I had to order it in a bit of a rush, so didn't do my research properly, and have only just realised it doesn't have an s-video port (I thought s-video was pretty standard these days?). This is a...

I've been trying to figure this out for the last couple of hours. Any help appreciated! I have a cell, say B2, and want to add an IF statement to it. If the statement returns true, I want to run a function which will change the colour of B2. I think that IF statement would look something like...

I'm back, and I'm stuck (again) I need to sort a lot of data in Excel. I could potentially have about 180 columns and 500 plus rows. I need sort A3 to IG500, using column F to column IG as Keys (rows 1 and 2 are Headers). How can I do this without having to write Key1:= ... Key2:= ...

Perfect! Thanks so much. Can leave the office happy now!

I'm stuck again! I've created 2 variables, ChangeStart and ChangeEnd, and have set their cell addresses. Dim ChangeStart As range Dim ChangeEnd As range Set ChangeStart = ActiveSheet.Cells(Target.Row, 5) Set ChangeEnd = ActiveSheet.Cells(Target.Row, 10) I need to take the range of cells...

Yay! Thank you both for the quick replies! Have spent ages today trying to work this out! Much appreciated!

Hi I haven't used VBA much, but have managed to muddle together a small macro. However, I'm stuck on one thing and I'm not having much luck googling it, as not really sure what words to search for... My macro starts: Private Sub Worksheet_Change(ByVal Target As range) Now, I need to create...

Having worked on intranets for several years, and now faced with redundancy, I am thinking about relaunching myself and trying to get a job developing web (internet) pages, and, if possible, writing content for the pages too Bit of a cheeky brain-picking question perhaps, but I was wondering...

Hi Hope I explain this OK.... How can I seach through a list of values in a spreadsheet column until i find a value which matches one that I specify. I have the basic IF statement: =IF(C2 = A2,B2). Where C2 holds the value I'm trying to find, A2 holds a value which might be a match and B2...

Hi Hope I explain this OK.... How can I seach through a list of values in a spreadsheet column until i find a value which matches one that I specify. I have the basic IF statement: =IF(C2 = A2,B2). Where C2 holds the value I'm trying to find, A2 holds a value which might be a match and B2...

Hi, thanks very much for the reply. I'm not sure I explained myself well... I only want the underline to appear when the mouse pointer is hovering over the link. As I said, this works ok with links which haven't been visited before, but on visited links, when I hover over them, the underline...

ooops, I meant to say that on visited links the underline is never there

Hi, I'm trying to set it up so that the links on my nav menu are not underlined unless the user is hovering over them. To do this I added some stuff to my style sheet: <style type=&quot;text/css&quot;> <!-- a:link { text-decoration:none } a:visited { text-decoration:none } a:hover {...