Increment cell range

[djhatrick12]

i want to increment the range I am pasting to from C5 to C41

Please Login or Register  to view this content.

i was thinking I could do something like this, but it keeps giving me errors

Please Login or Register  to view this content.

[watersev]

hi, djhatrick12, can you explain what do you have and what should be the result?

[djhatrick12]

I think that I figured it out.

Does is make sense to do :

Please Login or Register  to view this content.

I think that works....

But what if I have a string called "sFile5"

how would I increment the 5 from 5 to 41 also? Is there any way to connect it to the "i" I am unsing?

[jwright650]

Please Login or Register  to view this content.

.....don't you want to go from 5 to 41?...and not row5+i (ie row10 through 46)

If so try the red line above.

[djhatrick12]

Awesome. Yeah that makes more sense. Thanks a lot!

Now how do you mark the post as answered?

[jwright650]

go back to your first post in this thread and "edit"...Go Advanced....change title prefix to Solved