Hi,
i have 3 sheets that i need to Insert A new row using a short snippet. TBH I created more than 3 Macros
but i'm getting On and Off the error "No Responding" and also the macro its taking too long, Already follow the advice of Microsoft and forums expert to Eliminate any external new Add-in that is not from microsoft
Already try it to fix this on different ways and this is one of them.
This is what i need to achieve
sheet1
On Row 37
a-.I want to Insert new row (which have data) So, with this action the row with data Scroll down
b-.Drag Up Row C38 to new Row 37 (to drag the formula)
c-.Ignore Cell D38 and D37
d-.Drag Up Row E38:EI38 to E37:EI37
Sheet2
On Row 37
a-.I want to Insert new row (which have data) So, with this action the row with data Scroll down
b-.Drag Up Row C38:EI38 to Row C37:EI37 (to drag the formula)
Sheet3
On Row 37
a-.I want to Insert new row (which have data) So, with this action the row with data Scroll down
b-.Drag Up Row C38:EI38 to Row C37:EI37 (to drag the formula)
So, My question is: Do some expert know a Short Snippet to drag Up like 250 formulas Other than the Conventional VBA Record Macro dragging?
For example
Via Record Macro, This is the conventional Snippet to Insert New row and Drag it.
This is the New code that im trying now, but i need the Short Drag snippet
(who know, it may make a difference )
NOTE: On my codes I'm using the snippets to run faster.
Thank you so much
Bookmarks