-
WSDeb G.
AskWoody LoungerThanks very much Hans! That did the trick.
-
WSDeb G.
AskWoody LoungerYes, 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
-
WSDeb G.
AskWoody LoungerThank 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!
-
WSDeb G.
AskWoody LoungerNot 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 -
WSDeb G.
AskWoody LoungerThanks 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!
-
WSDeb G.
AskWoody LoungerThanks 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!
-
WSDeb G.
AskWoody LoungerThanks 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.
-
WSDeb G.
AskWoody LoungerHello 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!
-
WSDeb G.
AskWoody LoungerThanks 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!
-
WSDeb G.
AskWoody LoungerOh 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
-
WSDeb G.
AskWoody LoungerHere 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.
-
WSDeb G.
AskWoody LoungerThe 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.
-
WSDeb G.
AskWoody LoungerA 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 IfI 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
-
WSDeb G.
AskWoody LoungerI 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.
-
WSDeb G.
AskWoody LoungerThanks 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!
![]() |
There are isolated problems with current patches, but they are well-known and documented on this site. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
KB5061768 update for Intel vPro processor
by
drmark
2 hours, 9 minutes ago -
Outlook 365 classic has exhausted all shared resources
by
drmark
3 hours, 12 minutes ago -
My Simple Word 2010 Macro Is Not Working
by
mbennett555
14 hours, 12 minutes ago -
Office gets current release
by
Susan Bradley
18 hours, 56 minutes ago -
FBI: Still Using One of These Old Routers? It’s Vulnerable to Hackers
by
Alex5723
1 day, 11 hours ago -
Windows AI Local Only no NPU required!
by
RetiredGeek
19 hours, 59 minutes ago -
Stop the OneDrive defaults
by
CWBillow
1 day, 12 hours ago -
Windows 11 Insider Preview build 27868 released to Canary
by
joep517
1 day, 22 hours ago -
X Suspends Encrypted DMs
by
Alex5723
2 days ago -
WSJ : My Robot and Me AI generated movie
by
Alex5723
2 days ago -
Botnet hacks 9,000+ ASUS routers to add persistent SSH backdoor
by
Alex5723
2 days, 1 hour ago -
OpenAI model sabotages shutdown code
by
Cybertooth
2 days, 1 hour ago -
Backup and access old e-mails after company e-mail address is terminated
by
M W Leijendekker
1 day, 14 hours ago -
Enabling Secureboot
by
ITguy
1 day, 21 hours ago -
Windows hosting exposes additional bugs
by
Susan Bradley
2 days, 9 hours ago -
No more rounded corners??
by
CWBillow
2 days, 5 hours ago -
Android 15 and IPV6
by
Win7and10
1 day, 19 hours ago -
KB5058405 might fail to install with recovery error 0xc0000098 in ACPI.sys
by
Susan Bradley
2 days, 22 hours ago -
T-Mobile’s T-Life App has a “Screen Recording Tool” Turned on
by
Alex5723
3 days ago -
Windows 11 Insider Preview Build 26100.4202 (24H2) released to Release Preview
by
joep517
2 days, 19 hours ago -
Windows Update orchestration platform to update all software
by
Alex5723
3 days, 8 hours ago -
May preview updates
by
Susan Bradley
2 days, 19 hours ago -
Microsoft releases KB5061977 Windows 11 24H2, Server 2025 emergency out of band
by
Alex5723
2 days, 11 hours ago -
Just got this pop-up page while browsing
by
Alex5723
3 days ago -
KB5058379 / KB 5061768 Failures
by
crown
2 days, 21 hours ago -
Windows 10 23H2 Good to Update to ?
by
jkitc
1 day, 23 hours ago -
At last – installation of 24H2
by
Botswana12
3 days, 23 hours ago -
MS-DEFCON 4: As good as it gets
by
Susan Bradley
21 hours, 28 minutes ago -
RyTuneX optimize Windows 10/11 tool
by
Alex5723
4 days, 11 hours ago -
Can I just update from Win11 22H2 to 23H2?
by
Dave Easley
2 days, 10 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.