Thread replies: 10
Thread images: 3
Thread images: 3
File: 18it4s.jpg (117KB, 666x500px) Image search:
[Google]
117KB, 666x500px
>Be me
>Need to create an Excel macro that performs the same steps on multiple files, all of which have a different number of rows of data.
Essentially, I want the macro to run on "Every Row between Row 1 and Row X"; with Row X being the last row with data in it. It is possible to do this dynamically?
Seems like it would be doable if I were able to define the 'X' value by using a For Loop (ie. For every time a row has data, increase the value of X by 1... until X equals the number of rows with data in this particular file)
Is this possible in Excel VBA? I've never had to dick around with it before now.
>>
File: 1472179291446.jpg (517KB, 1024x678px) Image search:
[Google]
517KB, 1024x678px
shameless self bmup
>>
Install Gentoo
>>
File: 1483718336459.jpg (26KB, 600x592px) Image search:
[Google]
26KB, 600x592px
>>58536601
Thanks that fixed it
>>
>>58536242
There is While and Do Until loop for such cases
>>
Convert to CSV and do it in powershell
>>
>>58536242
>Be me
>>>/r/eddit
>>
>>58536242
iNSTALL GENTOoo REEEEEEEE!!!!
>>
>>58536242
Who are you quoting?
>>
>>58536242
Dim lastrownumb, i as integer
lastrownumb = Range("A1").CurrentRegion.Columns.Count
For i = 1 to lastrownumb
Range("A" & i) = blablabla
Next i
I'm on a bus and this is off the top of my head, but this should give you a good starting point
Thread posts: 10
Thread images: 3
Thread images: 3