multi-line VBA not working after column order change

[cmccabe]

I changed the order and now the below line of code does not seem to work when the VBA is run. I attached the workbook as well. Thanks.

Please Login or Register  to view this content.

[protonLeah]

You don't need the With.. block.
You have .Cells(iGender).Value
It should be .Cells(irow, iGender).Value

You need to make similar changes through out.

[cmccabe]

Removed the with block and replaced it and get unqualified or invalid reference. Thanks.

Please Login or Register  to view this content.

[protonLeah]

You don't need the With rData.Rows(iRow)... because the code in in the sheet module.

Please Login or Register  to view this content.