myvar

Hi, I'm currently writing an automated process that opens up a productivity report (xls) and has to add together a bunch of different times to work out a total. Now, when I try to add together the values from individual cells, rather than adding together the raw value within the cell, I get a...

Hi Everyone, I'm a newbie to the forum & only a beginner in VBA trying to self teach myself as I did with MS Excel, so would be grateful for your assistance & advice. So here's my problem... I've got a large data set table of information with various row records identified by a unique...

Hello All, I was wondering if anyone could help me with this. I've been trying to figure it out for days now, but just can't. below I have a code which allows me to change the value in a cell with a double click. I can do this in any cell in the worksheet. the problem is, I only want to be...

I tested this script and it walks through all 27000 cells (D3 - AZ500), changing each that is not blank to a red background: Dim MyVar As String Dim i As Integer Range("D3").Select For i = 1 To 27000 If ActiveCell.Value = "" Then ActiveCell.Offset(1, 0).Select Range("D" &...

Is it necessary to always clear your variables in a loop? For example, of the two methods below, which is preferable or are both the same? Dim MyVar As Class1 For Each Cell In Rng Set MyVar = New Class1 Call MyVar.SomeMethod Set MyVar = Nothing Next Cell or Dim MyVar...