Excel VB: How do I apply a VBA code to one column only

I want to be able to click a button where the code behind the button looks at just one volumn from say A4 to A9999. Whats the best way to do that in Excel Macro


Thanks

Are you trying to select the column? Or look at each cell in the column for specific information? Or what? What do you want the button to do?

Originally Posted by LaffyAffy13

Are you trying to select the column? Or look at each cell in the column for specific information? Or what? What do you want the button to do?

I am trying to apply a code only to a single column. I am checking all cells in the column if they have more than 2 decimal places on the click of a button. If they do, the row is highlighted.


Thanks

What jeffreybrown gave you should work. As for the cells with more than 2 decimal places, I haven't a clue how to identify them all. If the cells are formatted as a "Number" and not "General", then here is how to highlight all of the rows that have 3 decimal places. Maybe that can give you an idea. This would go exactly where jeffreybrown has written "'Run macro here"

Please Login or Register  to view this content.