Tags » Vba

Column Letters and Numbers

Say you’re working with columns and need to use the number rather than the letter to work with one of your loops or vide-versa. These work beautifully for this. 71 more words

VBA

Conway's Game of Life for Excel

I always wanted to use MS Excel for a really, really useful project! You know, something like these amazing tools, which allow you to convert a picture into an array of cells on the Excel spreadsheet. 69 more words

My Projects

#Excel: Using Conditional Formatting to Highlight 3D Formulas with Defined Names by David Hager

There was a comment on LinkedIn about my post about using CF to highlight 3D formulas

“Since I never use a direct reference (or, come to that, enter a formula without naming the range to which it applies) any 3D reference I might use would pass under the radar. 301 more words

Excel

Scan Data (VIRUS)

Number of images: 1
Attachment File Type: PDF

Description *

File analysis :

OPEN : Scan_*.pdf
SHA256 : d1efbca78f8847005a369ec24155723ccd257e58cd282429cc04f76f898743b7
RESULT : FILE IS A VIRUS… 99 more words

Trojan

Scan Data (VIRUS)

Number of images: 1
Attachment File Type: PDF

Description *

File analysis :

OPEN : Scan_*.pdf
SHA256 : d1efbca78f8847005a369ec24155723ccd257e58cd282429cc04f76f898743b7
RESULT : FILE IS A VIRUS… 99 more words

Trojan

If I want...

This could also use an if statement as a formula, but it forms a basis for if-then-else statements.If B2 is x then we set C2 to 4, if it’s anything else then C2 is set to 0. 30 more words

VBA

VBA: How to Condense Two Columns into a List

You know what I’ve wanted all my life? A way to condense columns into comma separated lists. I’ve been in multiple jobs where this would’ve been handy because it’d be so much easier to see all the things in a few rows. 211 more words

Gif Guides