Hi everyone, i have a small problem.
I wish to populate two combo boxes from two lists in the (A) and (B) column in excel. I can get the row count for column A but I can't get seem to get the correct row count for the second column. My statement look like this:
rowACount = currentsheet.range("A1"
.currentregion.rows.count
For some reason this doesn't work for any other column. Please help.
Jcan
I wish to populate two combo boxes from two lists in the (A) and (B) column in excel. I can get the row count for column A but I can't get seem to get the correct row count for the second column. My statement look like this:
rowACount = currentsheet.range("A1"
.currentregion.rows.countFor some reason this doesn't work for any other column. Please help.
Jcan
