When a macro won't cut it, try a VBA script

re: When a macro won't cut it, try a VBA script

GoodwinMeyers — Mon, 26 Dec 2011 12:19:05 GMT

Thanks so much for the post! It really got more handy this way. I used to resort to PDF converter http://openpdfconverter.com/ in this case and now there's no need to.

re: When a macro won't cut it, try a VBA script

Brucem77 — Mon, 26 Dec 2011 10:26:16 GMT

I found your resume blog very useful. Thanks for the information

sampleresumedirectory.com/teachers-resume

re: When a macro won't cut it, try a VBA script

Me Happy — Thu, 22 Dec 2011 13:47:45 GMT

Hello all,

I have formula or VBA problem and I'm hoping can help me. My column A contains the formula =Today()

Now based on dates on want to have a custom message that will appear depending on the due date and the finised date.

so basically I need something like this.

=IF A>E;"LATE" = Late

=IF A<=E;"PENDING" = Pending

and my last would be if the colomn (finished date is not null) then case follow-up = Terminated

Hope this is making any sense

Thanks for any help

re: When a macro won't cut it, try a VBA script

David Fuji — Wed, 14 Dec 2011 01:18:32 GMT

Good Post Daniel, I found it very useful. Is it possible to use a pivot table as the named range for the variant?

re: When a macro won't cut it, try a VBA script

Joe Tandle — Tue, 06 Dec 2011 00:07:06 GMT

I really like this post Daniel. Thanks for putting it up. I found an easy VBA script to do something on any dynamic range that is really useful.

Sub OnlyDoIfValue()

Dim lastrow As Long, mycell As Object

‘Find the last row in Excel

Range(“a65000″).End(xlUp).Select

lastrow = ActiveCell.Row

‘Define the Dynamic Range

Set myRange = Range(“b1:b” & lastrow)

For Each mycell In myRange

‘Puts in something to the right of the range

mycell.Offset(0, 1) = “Something”

End Sub

taken from:

newyorkinteractivemedia.com/.../excel-2010-macro-dynamic-range

re: When a macro won't cut it, try a VBA script

PremSivakanthan — Sat, 26 Nov 2011 01:56:30 GMT

Great post Daniel..! Interesting how you use the vStudents variant variable: you havent used any parentheses after dimensioning it, and you havent used a redim statement to size it either. I've always done both of these when using variant array variables like this (because I thought I had to). Can anybody shed light on this?? Prem

re: When a macro won't cut it, try a VBA script

smabres — Thu, 24 Nov 2011 14:16:44 GMT

Very nice example for Tables, classic programing, nothing fancy yet exquisite, thanks so much.

Sergio

re: When a macro won't cut it, try a VBA script

ShelLuser — Wed, 23 Nov 2011 08:52:50 GMT

Very good post, kudo's to you! The usefulness of VBA cannot be stressed out enough in my opinion. It really looks much more intimidating than it actually is and taking the time to become more familiar with it can actually safe you lots of time in the long run.

When done right the sky can become the limit here. VBA can even go as far as accessing remote data which can then be made available in your Office environment.