therock003
Board Regular
- Joined
- Jan 9, 2008
- Messages
- 189
I want expand some IP ranges and i'm having some trouble.
For example let's say I have 10.0.0.0-10.0.150.255.
Starting From left to right i would go,
10.0.0.0|10.0.0.1|......|10.0.0.255
And then From Top to Bottom
10.0.0.0
10.0.1.0
....
10.0..255.0
But dragging doesnt help from Top to Bottom, all it does is go like
10.0.0.0
10.0.1.0
10.0.0.1
10.0.1.1
etc....
Which is completely wrong. How can i autocomplete this correctly, without hassling hassling with VBA?
Also is there some kind of superdrag, where you dont have to frag that far down, or right? Like say you want to drag from cell A to cell X, and get done with all at once. This would be helpful with future practices as well!
For example let's say I have 10.0.0.0-10.0.150.255.
Starting From left to right i would go,
10.0.0.0|10.0.0.1|......|10.0.0.255
And then From Top to Bottom
10.0.0.0
10.0.1.0
....
10.0..255.0
But dragging doesnt help from Top to Bottom, all it does is go like
10.0.0.0
10.0.1.0
10.0.0.1
10.0.1.1
etc....
Which is completely wrong. How can i autocomplete this correctly, without hassling hassling with VBA?
Also is there some kind of superdrag, where you dont have to frag that far down, or right? Like say you want to drag from cell A to cell X, and get done with all at once. This would be helpful with future practices as well!
