error #438

I'm working on a sheet that spans two pages, and I'm trying to format the page setup in VBA (as the culmination of a number of other operations the macro is executing). Since the result is on only two pages, it doesn't matter to me whether it's odd/even pages or different first page. In my page...

Hi, I need some help with my code.. The program is supposed to match payments according to three criteria: 1) invoice number, 2) date of payment and 3) amount paid. The program reads each row of Sheet 1, scans all 3 criteria mentioned above and will search for it in Sheet 2 (Bank Statement)...

I basically copied code from a macro to sort and I get errors with a minor tweak. I'm not sure what's wrong. Public Sub PopulateXL(varArray2Write() As Variant, strTitle As String) Dim xlappApp As Excel.Application Dim wkbkMain As Workbook Dim wkshtMain As WorkSheet Dim lngRowCount As Long...