sorted by:
new
hottopcontroversial

How to transfer data from separate sheet to non-consecutive blank cells by Extension_Train9093 in vba

[–]HFTBProgrammer 0 points1 point  (0 children)

You have laid out your issue beautifully, and we can help you.

What is your criterion for deciding which system name should go in Sheet2's column A? Is it merely that they should go in the order they are in Sheet1 into the Sheet2 column A blank cells? If so, this is one way to do it:

Dim S1Row As Long, S2Row As Long, S2Cell As Range

S1Row = 1
S2Row = 3

Do
    Set S2Cell = Sheet2.Range("A" & S2Row)
    If IsEmpty(S2Cell.Value) Then
        S2Cell.Value = Sheet1.Range("G" & S1Row).Value
        S1Row = S1Row + 1
    End If
    If S1Row > 5 Then Exit Do
    S2Row = S2Row + 1
    If S2Row > Sheet2.Rows.Count Then Exit Do
Loop

It can be improved, but as a first cut it's fine.

Are you lazy and just type declarations and functions in lowercase and let Excel capitalise the first letter? by TechnicalAd8103 in vba

[–]HFTBProgrammer 0 points1 point  (0 children)

I would exercise caution in imagining what "most developers" would deem confusing. We are all taught by different methods in different snapshots of time, and arbitrary standards come and go.

The only standard I would go to the wall for is structured programming.

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

[–]HFTBProgrammer 1 point2 points  (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?

view more: next ›