hi Experts,
Once again am back with another query on Autofilter
i could able to manage Advance filter criteria function perfectly in case
of one criteria but unable to proceed in case if two criteria or existing
Ex: In Column A i need filter only1, 2
and in columnd i need filter on
; efficient, simpler, easier to follow, and less error-prone to just perform
> the action on the range. For example, you have
>
> Rows("102:" & k).Select
> Selection.Delete Shift:=xlUp
>
> This could be
>
> Rows("102:" & k).Delete Shi
Hi Experts,
Does any one of you have finance models which are built in excel or any
excel analytics related spreadsheets. i am basically appearing for
financial planning and analysis interview so just in case if any of you
have such models please do share with me..
Thanks,
Ram
--
Are you =EXP(E
hi All,
please guide me how to declare variable to save the new worbook with Names
listed in A column.
i am trying to create new workbook and also rename that sheets as per
defined names in column b, or c or d tabs respectively.
Col A Col B Col C Col D
RAMTODAY TOM
not, where is the
> active cell after this line is run?
>
> Regards
> David Grugeon
>
>
>
> On 28 April 2013 16:36, excel learner wrote:
>
>> hi David,
>>
>> I tried step by step execution but still it is executing fine without any
>> error but deletio
hi Team,
Can anyone please resolve my concern.
Thanks.
On Sun, Apr 28, 2013 at 12:06 PM, excel learner wrote:
> hi David,
>
> I tried step by step execution but still it is executing fine without any
> error but deletion part in first transaction tab is not done..
>
> Thank
hi David,
I tried step by step execution but still it is executing fine without any
error but deletion part in first transaction tab is not done..
Thanks & Regards,
Ram
On Sun, Apr 28, 2013 at 12:04 PM, David Grugeon wrote:
> You have highlighted 5 lines
>
> Try stepping through the code and f
