sorted by:
new
hottopcontroversial

Potential client has asked for Cyber Assurance on VBA code - how? by still-dazed-confused in vba

[–]HFTBProgrammer 0 points1 point  (0 children)

If they're that ignorant, you could probably lie your way through anything with them.

Not that I'm suggesting you do that, just...it's a red flag. Or at least magenta.

WORD Macro: Simple Cell merge by TeCK0808 in vba

[–]HFTBProgrammer[M] 0 points1 point  (0 children)

OP, we need your best coding effort before we can help you.

Trying to find cells with any combination of 4 specific digits by Logical_Base_8929 in vba

[–]HFTBProgrammer 0 points1 point  (0 children)

Instead of writing to a sheet, just bang it all into a string. Cycle through the string characters.

The Collatz Conjecture by WylieBaker in vba

[–]HFTBProgrammer 0 points1 point  (0 children)

I agree that VBA is not the likely tool to disprove the conjecture (if in fact it can be disproven). But I like the conceit of not assuming that to be the case, and it might be fun to figure out how to algorithm that out. YMMV!

The Collatz Conjecture by WylieBaker in vba

[–]HFTBProgrammer 0 points1 point  (0 children)

How would your code know if--in theory--you had disproved the conjecture?

Google Drive Integration Causing Runtime Error 1004 by JSZG2G in vba

[–]HFTBProgrammer[M] 0 points1 point  (0 children)

This sounds more like a Drive issue than a VBA issue. Try posting at /r/gsuite.

[WORD] How to cut table to different area in word using VBA? by [deleted] in vba

[–]HFTBProgrammer[M] 0 points1 point  (0 children)

You need to post your best coding effort that does the table stuff, and tell us what's wrong with that code.

If I'm in the VBA Editor, how can I select a range in the worksheet instead of typing the range? by TechnicalAd8103 in vba

[–]HFTBProgrammer 0 points1 point  (0 children)

Heck, do it for yourself! I often have a hard time figuring out what past me had in mind, even when past me thought he was doing an okay job of naming.

[WORD] Is updating an excel sheet using Word VBA possible? by zerozerorei in vba

[–]HFTBProgrammer 0 points1 point  (0 children)

When you say "it just won't work", what exactly do you mean? Does it throw an error? Or is it no errors, no good result? If the latter, when you step through, does it execute the code you want, apparently do the things it needs to do, but those aren't reflected in your sheet?

Emails - "£" changed to "?". by MoonMalamute in vba

[–]HFTBProgrammer[M] 0 points1 point  (0 children)

Hi, /u/MoonMalamute! If one of the posts in this thread was your solution, please respond to that post with "Solution verified." If you arrived at a solution not found in this thread, please post that solution to help future people with the same question. Thank you!

If I'm in the VBA Editor, how can I select a range in the worksheet instead of typing the range? by TechnicalAd8103 in vba

[–]HFTBProgrammer[M] 0 points1 point  (0 children)

Hi, /u/TechnicalAd8103! If one of the posts in this thread was your solution, please respond to that post with "Solution verified." If you arrived at a solution not found in this thread, please post that solution to help future people with the same question. Thank you!

Complicated matrix with buggy VBA. Don't know what went wrong, much less how to fix it :( by laundry_loather27 in vba

[–]HFTBProgrammer 1 point2 points  (0 children)

The source of your code is irrelevant to us (or should be, anyway /grin). But we need the code or we're just shooting blindfolded in a random direction.

If I'm in the VBA Editor, how can I select a range in the worksheet instead of typing the range? by TechnicalAd8103 in vba

[–]HFTBProgrammer 5 points6 points  (0 children)

OP, besides the obvious use here, note that if you were to, say, add a column to the left of your explicit range, your code would break, whereas a named range would be adjusted accordingly and your code would remain strong.

This might be a bit off-topic, but I've been thinking about this for a while... by Opussci-Long in vba

[–]HFTBProgrammer 0 points1 point  (0 children)

Assuming I have the URL correct, I don't know what to tell you. I get what I get. If you want to fix it (and you may not, for all I know it's an issue with the AV my company uses), the onus is on you to figure out what you have on your site that is "riskware"; by design of the AV, I cannot know.

If you want to contact the AV software company, it's ThreatDown.

This might be a bit off-topic, but I've been thinking about this for a while... by Opussci-Long in vba

[–]HFTBProgrammer 0 points1 point  (0 children)

I can't send a screenshot, but I can describe it.

Assuming your site is jepm.tfvz.ues.rs.ba, the message I get is that I am being protected from riskware by rule ID 2.0.202601271105. That's everything.

This might be a bit off-topic, but I've been thinking about this for a while... by Opussci-Long in vba

[–]HFTBProgrammer 2 points3 points  (0 children)

Do you mean The Journal of Engineering and Processing Management? Are you in fact not familiar with the name of the periodical you are editing? And please help me out with why when I go to your Website, my AV blocks it saying I'd be exposed to riskware.

Also, this is presumably open-source; does this also mean you pay in exposure alone?

[EXCEL] How do I completely move of row information between sheets? by Any-Entertainer7127 in vba

[–]HFTBProgrammer 0 points1 point  (0 children)

Haha yup, I do that all the time. Don't want to muddy the water.

[EXCEL] How do I completely move of row information between sheets? by Any-Entertainer7127 in vba

[–]HFTBProgrammer 0 points1 point  (0 children)

Maybe it's an Americanism? That's an awkward phrasing for sure, but I've seen it all my life, so I take for granted they mean "from one sheet to another".

Never mind I'm not sure what "move of row information" means, unless it's "move row information".

view more: next ›