I am using a formula like h13=if(a13>0,mid(a13,7,8)," ")
h16=if(a16>0,mid(a16,7,8)," ")
similarly after three after three my formula should grag down but when i drag holding thezse two rows,it doesnt execute well..
I am using a formula like h13=if(a13>0,mid(a13,7,8)," ")
h16=if(a16>0,mid(a16,7,8)," ")
similarly after three after three my formula should grag down but when i drag holding thezse two rows,it doesnt execute well..
Hi Rohan,
Select H13 to H18 & then drag down
Click on * below if you find this helpful
Thanks,
A
Wow it worked..but how?
For gap,one should select 5 rows ,is it like that
Running well for small range,but when we are pulling or draging it to 70000 rows its not well
No in other way simply select H 13 to H 15 & drag you will get same result ,
selection says repeat first cell after every tow cell
it should work properly for n numbers of rows
You need to select 2 extra cells at he end (6 cells total) for the complete pattern - then drag down
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks