Divide By Gives Whole Number (Excel 2003 VBA)

Topic

New Reply

Hello, wondering if someone can help on couple of things.

What is the quickest way to find the column number for a column heading. I normally do while “Address” and use a counter. Is there a better way?

Second I need to quick if a cell value divided by three is a whole number. Again what is the easiest way?

Thanks is advance.

Reply | Quote

Replies

Hi,
You can use something like:
activesheet.rows(1).find("Address").column
You can use If rngCell.Value Mod 3 = 0 then to check the division by three.
HTH

Reply | Quote