“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I have this code - and would like to have it applied to all the cells (G2:G66666) but that the code applies to its adjacent cell on the left.
Option Explicit
Sub test()
Dim a, i As Long, mytxt As String, temp As Long, msg As String, lastRow As Long
a = Range("a1").CurrentRegion.Value
For i = 1 To UBound(a, 1)
a(i, 1) = GetAsValue(a(i, 1))
a(i, 2) = GetAsValue(a(i, 2))
Next
mytxt = Range("f2").Value
temp = GetAsValue(mytxt)
If temp = 0 Then
Range("G2").Value = "Invalid postalcode"
Exit Sub
End If
For i = 1 To UBound(a, 1)
If (Not IsError(a(i, 1))) * (Not IsError(a(i, 2))) Then
If (temp >= a(i, 1)) * (temp <= a(i, 2)) Then
msg = a(i, 3)
Exit For
End If
End If
Next
Range("G2").Value = msg
End Sub

Solved by C. H. in 22 mins

File has an invalid extension. It is a macro enabled file that you guys made for me and it isn't working any longer.

Solved by M. U. in 29 mins

In the Years of Service column, modify the formula to include the IFERROR function and display the message "invalid hire date" if an error value occurs.

Solved by Z. Q. in 23 mins

In the Years of Service column, modify the formula to include the IFERROR function and display the message "Invalid hire date" if an error value occurs. Test the modified formula by changing the date in cell E2 from 7/10/2014 to 17/10/2014.

Solved by V. U. in 19 mins

trying to macro pivot table on a same sheet. it worked initially but does not work anymore and error code invalid procedure call or argument pops up.
formula below...
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, sourcedata:= _
"R1C1:R999C5", Version:=6).CreatePivotTable TableDestination:= _
"R1C7", TableName:="Pivot table1", DefaultVersion:=6

Solved by M. E. in 26 mins

I want to set a rule on a cell.
I have candidates that have issue dates on DBS which is out of date if it goes passed 12 months of their issue date, however if its on the update service even if it goes over 12 months on the issue date is still in date.
normally to work out whether it is invalid I would =cell+365 for the amount of days it is passed the issue date and when it goes passed the 365 it automatically highlights red

Solved by O. Y. in 16 mins

In cell Q3, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, the text “Invalid Staff ID” should be displayed by the formula.

Solved by M. L. in 26 mins

I am trying to make a clocking in sheet. I spoke to an advisor earlier and he added some macros for me. I need to extend the whole sheet down and also do the same in the clocking out column. The file won't upload because it is saying invalid extension.

Solved by G. S. in 12 mins

In cell Q3, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, the text “Invalid Staff ID” should be displayed by the formula. (Hint: You can test that this formula is working by changing the value in cell Q2 to 0, but remember to set the value of cell Q2 back to 1036 when the testing is complete.)

Solved by M. J. in 25 mins

two questions the first question being the easier of the two,
I know how to calculate the difference between two times however when working out the difference between two times that cross over midnight the answer is coming up as invalid, can you help me?
question 2:
I want to be able to enter a date, start time and end time of a shift and in the next column it use a formula to select the right cell in the grid above in reference to the in date and start time i have entered. is there a way to do this?

Solved by D. Q. in 18 mins