Thank you DP
Your explanation was extraordinary. In addition to solve my problem, you taught
me a lot! ;)
Thank you very much again
Regards
Isabel
On Monday, September 14, 2015 at 7:37:57 PM UTC-5, De Premor wrote:
>
> Hi Isabel,
>
> I'am glad that its work, ok here is the problem in out 2nd
Hi Isabel,
I'am glad that its work, ok here is the problem in out 2nd case
1st, we need to step back to learn about how the function work,
cpearson.com have a bunch article about this complete with explanation &
sample, you can follow this link
*http://www.cpearson.com/excel/optionalargumentst
Thank you DP!
Thank you very much for your help. It worked perfectly.
However, I tried to do the same in Calculation2 sheet, but inserting rows
instead of columns and it did not work the same logic. It gives me a syntax
error.
Could you help me fix this?
I used:
Dim v As Integer
v = Range("Mont
We can avoid using loop in this case, try to replace your looping code
with offset and resize, try this another solution
Dim u As Integer
u = Range("Months").Value - 1
If u > 1 Then
Range("ColumnLong").Resize(, u).Insert
Range("ColumnFormula").Copy
Range("ColumnLong").Offset(, -u).R
Hello Ashish,
Thank you for your response.
This is a simplified copy of my macro. The lines you can find there are
repeated
multiple times in my final workbook, in different spreadsheets because it
has a broader mathematical formulation.
Hope this helps,
Regards
On Saturday, September 12, 201
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
> takes a lot of memory.
>
> Regards,
> Isabel
>
>
>
> On Saturday, September 12, 2015 at 9:20:05 AM
Thank you Basole for your message!
I have been already using your recommendation on my code, but it still
takes a lot of memory.
Regards,
Isabel
On Saturday, September 12, 2015 at 9:20:05 AM UTC-5, Basole wrote:
>
> Hi isabel, try using "Application.ScreenUpdating = False" To Turn Off at
> th
Hi isabel, try using "Application.ScreenUpdating = False" To Turn Off at
the start of code. and "Application.Calculation = xlCalculationManual" To
turn off the automatic calculation
at the beginning of the code
see example:
Dim u As Integer, v As Integer
u = Range("Months").Value - 1
Application.S
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
