Hi!
I couldn't get this to work. I want to right-align the first 3 columns, then I want to do the same thing again, but 5 columns off to the right and so on. I tried the below code, but it seems like it just repeats the align on the first 3 columns? I tried offseting it, but I didn't take![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
Any ideas? Really appreciate it!
I couldn't get this to work. I want to right-align the first 3 columns, then I want to do the same thing again, but 5 columns off to the right and so on. I tried the below code, but it seems like it just repeats the align on the first 3 columns? I tried offseting it, but I didn't take
![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
Any ideas? Really appreciate it!
Code:
For k = 1 To n
Range(Columns(1), Columns(3)).HorizontalAlignment = xlRight
ActiveCell.Offset(0, 5).Select
Next k