Hello Everyone,
I am a Newby to Excel VBA and as such, not competent at all. I am trying to create a number counter which runs up to a value which is determined by a COUNTIF Statement in the spreadsheet. I can get the number counter to run to the given value. However, due do formatting reasons I do not want the counter to start in cell A1 but A3 instead. Any Ideas on how I could solve this issue? Thanks a lot in advance!!!Hello Everyone,
I am a Newby to Excel VBA and as such, not competent at all. I am trying to create a number counter which runs up to a value which is determined by a COUNTIF Statement in the spreadsheet. I can get the number counter to run to the given value. However, due do formatting reasons I do not want the counter to start in cell A1 but A3 instead. Any Ideas on how I could solve this issue? Thanks a lot in advance!!! Essentially my code looks like this:
...
ActiveSheet.Cells(3, 1).Select
Dim i As Integer
For i = 1 To Range("A1")
Cells(i, 1) = i
Next i
...
I am a Newby to Excel VBA and as such, not competent at all. I am trying to create a number counter which runs up to a value which is determined by a COUNTIF Statement in the spreadsheet. I can get the number counter to run to the given value. However, due do formatting reasons I do not want the counter to start in cell A1 but A3 instead. Any Ideas on how I could solve this issue? Thanks a lot in advance!!!Hello Everyone,
I am a Newby to Excel VBA and as such, not competent at all. I am trying to create a number counter which runs up to a value which is determined by a COUNTIF Statement in the spreadsheet. I can get the number counter to run to the given value. However, due do formatting reasons I do not want the counter to start in cell A1 but A3 instead. Any Ideas on how I could solve this issue? Thanks a lot in advance!!! Essentially my code looks like this:
...
ActiveSheet.Cells(3, 1).Select
Dim i As Integer
For i = 1 To Range("A1")
Cells(i, 1) = i
Next i
...