10-08-2009, 02:51 PM
when you use cells in excel spreadsheet then a cell indicates a box on a particular row and column.
So whenever you need to have an operation on any cell then you will have to provide which row and which column.
So in your code when you use cells(1,5) that indicates you are working on a cell which is on first row and column 3.
see excel vba help for more info on this.
So whenever you need to have an operation on any cell then you will have to provide which row and which column.
So in your code when you use cells(1,5) that indicates you are working on a cell which is on first row and column 3.
see excel vba help for more info on this.