Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ckelly0172

  1. ckelly0172

    Excel Help

    Great stuff, Thanks C
  2. ckelly0172

    Excel Help

    Hi, a little help with excel please..... How can I calculate the values of certain range of cells dependant 2 different criteria? eg ColA ColB ColC jan 1 a jan 2 b jan 3 c jan 2 a feb 3 b feb 4 c mar 1 a mar 2 b mar 3 c mar 5 a What's the total values in COLB when jan and 'a' are true...
  3. ckelly0172

    Remote desktop

    thanks, makes sense if you have a flash wallpaper, however I just need a little ident. Anyhow, fixed.... Within Group Policy (type 'mmc' in RUN, FILE>add/remove Snap>add>group policy object editor>Finish>Ok>) and navigate to Terminal services (Comp Conf>Admin temp>Windows Compo>Term Serv...
  4. ckelly0172

    Remote desktop

    Thanks for your response kjv. Not much help I'm afraid, it doesn't state anywhere that the desktop wallpaper is available when RDP'd in. However, I did notice on the options of RDP, under performance, that you can allow the 'desktop background'.... but it doesn't. Starting to think its a...
  5. ckelly0172

    Remote desktop

    Hi all, I'd be very grateful for a little help.... I use rdp to connect to PCs we have a remote locations and I have found that certain properties in the Display settings are greyed out, such as desktop background and resolution. Is there a way of enable these settings so they're configurable...
  6. ckelly0172

    Help... lost a macro

    Hi, I have stupidly deleted a macro by mistake... and its a big one!! Is there any way of getting it back. Cheers Craig
  7. ckelly0172

    Excel - protection

    Superb.... works a treat. Cheers Gizmo Craig LUFC forever....
  8. ckelly0172

    Excel - protection

    hi.... Is it possible to protect a range of cells rather than the whole book or sheet. Thanks Craig
  9. ckelly0172

    separating data

    Could you please elaborate on the "named range". this is the line straight out of the editor:- myColour = WorksheetFunction.VLookup(c.Text, [ColourLkup], 2, False) and Iam having the "error 1004 uanble to get the Vlookup propertyof the Worksheetfunction class. C
  10. ckelly0172

    separating data

    Geoff, Having probs with the 'myColour = worksheetfunction.vlookup(c.text,[ColourLkup),2,false)' code. Giving me a "run time error 1004" c
  11. ckelly0172

    separating data

    Thanks Geoff, will give it a go.
  12. ckelly0172

    separating data

    Takin the above example, I'd like to differentiate each combination with any colour. eg all 'd1 on' = green 'd2 on' = blue... etc c
  13. ckelly0172

    separating data

    Dont think i can use conditional format as the data i have is like:- D1 on D2 on D1 off D2 off D1 down D2 up... etc Also, this data is in one cell wiht other attributed to it. Geoff, I require only 5 or 6 colours. Thanks for help chaps.
  14. ckelly0172

    separating data

    oop, should've mentioned the data i have is text not numerical... (if thats makes any difference???) c
  15. ckelly0172

    separating data

    Hi there, I have a long list of data and would like to separate the different types so that they are colour coded, either the cell or the text. eg, if the data is simply 1,2 or 3 then each number to be a different colour. Could do it manually but i have approx 50000 bit of data of differing...
See more

Part and Inventory Search

Back
Top