invalid qualifier

Hey all, I've had some success writing some simple VBA programs in the past, and right now I'm trying to make a VERY simple function that simply selects the last cell in Column A of my Worksheet "Test". Picture below. Now I've written programs more complex than this before using these exact...

When calling the following Sub I get an Invalid Qualifier Error near the bottom of the code "myEndRecordArray(i).Value = VLookupResult" Any thoughts? Sub PrintCountCounts() Dim myTableArray(1 To 6) As String Dim myEndRecordArray(1 To 6) As String Dim myPrintCountArray(1 To 6) As String Dim...

I'm eceiving an Invalid Qualifier Error for LastPartNo in Sub InputPart, even though I have clearly defined it as an Integer before I tried to use it. I attempted dding a Temp Str type as a go between in case of a type mismatch. Still no luck. Ay help would be much apreciated! :) lSub...

Hello, I am currently writing a section of a code that will display the results of a search function from an array. However, I keep encountering an 'invalid qualifier' error. Can someone please let me know why it keeps doing this? Dim Results1() as Variant Dim i1 as Integer Dim NextRow as...