• WSDeb G.

    WSDeb G.

    @wsdeb-g

    Viewing 15 replies - 46 through 60 (of 136 total)
    Author
    Replies
    • in reply to: Clear Drop Down in Pivot Table (2003) #1023834

      Thanks very much Hans! That did the trick.

    • in reply to: Word Exits when closing document (2003) #1022220

      Yes, that’s the one Andrew!

      Good going. I swear I put every combination of words in the search engine and that one didn’t pop up! But I do admit that I didn’t use the word “open” in my search combination…and I probably didn’t look as far back as 2002 grin

    • in reply to: Word Exits when closing document (2003) #1022208

      Thank you Hans. Closing Word as the email editor fixed this problem. We’ve even restarted Word as the editor and the problem hasn’t returned …yet!

    • in reply to: Spam deluge in OE6 (6.00.2900.2180) #1021910

      Not that I’m trying to pirate this thread but I was going to post something along these lines. My question is more of a curiousity than anything else because I don’t think the spam will ever come to a complete end.

      How do these spammers get email through to my account when they don’t even have my correct email address? Twice tonight I’ve had email sent to me that is using a variation of my actual address…how does that get through my ISP account ?

      Thanks,
      Deb

    • in reply to: Help with error message (SP2) #1019864

      Thanks Al!

      (I did a copy/paste of the error message from my sis’s email to me – didn’t notice the inconsistent slashes until after the post!) I do know that her system is only 6 months old but other than that, I don’t know many details without being in front of it. I’ll have a look at it using your suggestion and see what else I can find out. (She’s REAL nervous about doing anything to her computer so I KNOW she hasn’t tried CHKDSK)

      If I run into problems, I’ll post back!

    • in reply to: Install standard VGA driver (XP SP2) #1017563

      Thanks Bob.

      When I restart the computer after uninstalling the drivers a small bubble comes up at the bottom right of the screen that says Found New Hardware, VGA compatible, then the Wizard comes up. This happens twice because (and I don’t know a lot about these things) but I have two display drivers listed; the first is the HE Radeon 9250 and the other says HE Radeon 9250 (secondary). What I did was cancel both of these wizards thinking that would do the trick. In fact another bubble window appeared that said something like “hardware not installed properly, you may have problems”. Thinking I was good to go with the new driver installation, I carried out the installation process only to have an error window pop-up saying something like “video.inf not found”; then a second error window backs that one up by saying “install standard VGA driver first”.

      This is turning out to be quite the process!

    • in reply to: Install standard VGA driver (XP SP2) #1017546

      Thanks for the responses. I’m not at my own computer just now but I think I need to re-check what I downloaded. I currently have ATI’s High Excalibur Radeon 9250 display driver(s). I wanted to upgrade them so I went to ATI’s site and downloaded what I thought was the latest driver. When I try to install the new driver, I get an error message saying to install a standard VGA driver first….that’s where the problems started. Maybe I’ve just downloaded the wrong file.

    • in reply to: Macro: find value and copy data (2003) #1017365

      Hello Hans.

      As I’m trying to read this code, I have two things I don’t understand:

      1. In the line “Range(“A” & lngRow & “:F” & lngRow).Copy”, what does the &”.F” refer to/do?
      2. The first line of code is Dim IngSourceRow as Long. I may not be seeing it or understanding properly, but lngSourceRow doesn’t show up in the code anywhere else so I wondered why that line is there?

      Thanks for your patience!

    • in reply to: Macro: find value and copy data (2003) #1017331

      Thanks to you and Hans for your sound advice.

      I think the practice part is key…there is so much to remember in coding that unless I keep at it continually, I tend to forget some of the language. Thank goodness for great forums like this one though!

    • in reply to: Macro: find value and copy data (2003) #1017268

      Oh my….I don’t think I would have written anything that resembled that. I also thought that I was going to use some sort of Do Loop when the data moving was determined. Thank you for this.

      May I ask a question? In all my readings to learn to write code, it usually says to start with the macro recorder as it’s the best way to learn VBA. It may be helpful to learn small things like the syntax for formatting something etc., but how does one learn the gritty details i.e. writing something as you did for this example? I’ve been working at this problem on and off for a couple of months and have tossed out all kinds of different versions of code that in the end, didn’t work. I was determined to solve this particular task and, after seeing your code, I don’t think there is a hope in heaven that I could have “come up” with that.

      Sorry, I think my question turned into venting but the question still remains smile

    • in reply to: Macro: find value and copy data (2003) #1017264

      Here is a sample of the data. Once I have the macro for moving the data around, I am going to add to the code (which I believe I can do!) to format the new header columns. I should note that in the (terrible) code that I already have, I have taken care of creating the new headers for each column…it’s just moving the data that I can’t figure out.

    • in reply to: Macro: find value and copy data (2003) #1017246

      The data is being moved to new columns…all data corresponding with “a” will be moved to column H; “b” will be moved to column I, “c” will be moved to column J, and “d” will be moved to column K. As you may have gathered from my previous post, I am taking the data from a row and transposing it to the correct column. Is it easier if I post a worksheet showing the current data and desired outcome?

      Thank you Hans.

    • in reply to: Macro: find value and copy data (2003) #1017241

      A little late between posts but this is a project I am working at leisurely as an attempt to teach myself how to code. So far, it’s not working too well. I’ve discovered I don’t know enough of the “language” in order to write code.

      In a nutshell, what I have been trying to do is this: I have 4 different values that repeat randomly in column G; the values are a, b, c, and d. If there is data in columns A:F beside any value of “a” in column G, I want to move it elsewhere. The same goes for the values of b, c and d. Part of my difficulty is figuring out how to say all of this is a macro. All I have managed so far is the following which simply moves one set of data but doesn’t keep searching for other instances of “a” in column G:

      If Range(“G1”).Value = “a” Then
      Range(“A1:F1”).Copy
      Range(“H2”).PasteSpecial Transpose:=True
      End If

      I know that when I have figured out the above, I need to loop the whole thing but this middle bit has me baffled.

      Thanks for any help in advance.

      Deb

    • in reply to: Counting question (2003) #1014629

      I have this solved. Not a very pretty solution but it worked nonetheless. It involved creating a pivot table and adding a column beside the table that counted individual names…then subtracting the difference to see how many unique versus multiple items there were.

    • in reply to: Read Receipt question (2003) #1014574

      Thanks Hans. It is for an internal email but the organizaton is province-wide (server residing elsewhere) and I don’t want to mess with the big boys in Toronto! I think I’ll forego this one!

    Viewing 15 replies - 46 through 60 (of 136 total)