cellsz

Hello, I hope this is something obvious, but I can’t see it,effectively the basic formula works, but when I transpose that to vba, thecolumn just remains blank. Effectively, I want the sum of the figures in column Q,where column G matches the name in the relevant line in the first line...

Hello, This is a excel macro used to allocate hours in a tool "Promise" using Internet Explorer. It works fine on my Laptop, but when i run the same macro on another machine. it gives error. "session expired." when i run the macro step by step using F8 till the page...

When i try below code it gives me error. "Unable to get the Vlookup property of the worksheetFunction class". However when i copy paste vlookup formula used in VBA code in excell manually & change Cell(Z,2) value with B2 , then i gives right output. However when i keep Cell(2,2), it gives...

this code finds 2 non hypotenuse sides that form a right angle triangle then checks if it is a multiple of a previous "find". it finds nothing after 65 72 97 ie it does not find 65 156 169. J column is a list of prime numbers below 100 Sub Macro4() ' ' Macro4 Macro ' Macro recorded...