Insert
> Range("RowFormula").Copy
> Range("RowLong").Offset(-v).Resize(v).PasteSpecial Paste:=xlFormulas
> Application.CutCopyMode = False
> End If
>
> :D
> Hope it help, Rgds
> [dp]
>
> On 14/09/2015 23:12, Isabel Cristina Ortiz
ange("ColumnLong").Resize(, u).Insert
> Range("ColumnFormula").Copy
> Range("ColumnLong").Offset(, -u).Resize(, u).PasteSpecial
> Paste:=xlFormulas
> Application.CutCopyMode = False
> End If
>
> Rgds,
> [dp]
>
> On 14/09/2015
, 2015 at 2:19:22 PM UTC-5, ashish wrote:
>
> Can u pls share a sample file
> On Sep 12, 2015 9:38 PM, "Isabel Cristina Ortiz" > wrote:
>
>> Thank you Basole for your message!
>> I have been already using your recommendation on my code, but it still
>> take
lse
> Application.CutCopyMode = False
> Next v
>
> ElseEnd If
> Application.ScreenUpdating = True 'To Turn on at the end of the code.
> Application.Calculation = xlCalculationAutomatic 'To turn On the automatic
> calculation
>
>
> Regards.
Hello,
I have been working on a workbook. It is a cash flow and macro helps me to
change the numbers of years (columns) because each project needs different
time periods.
What I do is that I have two columns named as "ColumnLong" and
"ColumnFormulas". The first one is empty and only serves as a