Put this in your code before end keyword.
ActiveWorkbook.Worksheets(Consolidate).UsedRange.Sort
key1:=ActiveWorkbook.Worksheets(Consolidate).Range(b:b),
order1:=xlAscending, Header:=xlYes
On Tuesday, April 14, 2015 at 11:23:35 AM UTC+5:30, TAWHID wrote:
Hi Vaibhav,
I was
Wondering , If
Thanks a lot! while waiting I just did below code, and working which is
like your one.
With cs
.Range(A1).CurrentRegion.sort _
Key1:=.Range(B2), Order1:=xlAscending, _
Key2:=Range(G2), Order2:=xlDescending, _
Header:=xlYes
End With
Thanks agian!
On Friday, 10 April
Hello,
PFA file and am trying to get counts based on merged cells. I have given
comments in Column G. Could you help me on this.
Regards,
Chandru
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Sorry For the delayed reply. The name of that application is True count
its third party application.
Thanks.
On Sunday, April 5, 2015 at 4:52:50 AM UTC-4, Mandeep Baluja wrote:
what is the name of your application from which you're retrieving your
data.
On Saturday, March 28, 2015 at
Hello Mandeep,
Thanks for the formula. is there any way we can work on merged cells?
On Tue, Apr 14, 2015 at 4:00 PM, Mandeep Baluja rockerna...@gmail.com
wrote:
unmerge your cells and Fill it down to create a helper and use this
formula.
Regards,
Mandeep Baluja
On Tuesday, April 14,
Hello Mandeep,
Formula does not work when Column B is General Field(Mix of Text Number
format). Please find attached sheet.
Regards,
Chandru
On Tue, Apr 14, 2015 at 4:08 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hello Mandeep,
Thanks for the formula. is there any way we can
unmerge your cells and Fill it down to create a helper and use this formula.
Regards,
Mandeep Baluja
On Tuesday, April 14, 2015 at 2:21:19 PM UTC+5:30, Chandru wrote:
Hello,
PFA file and am trying to get counts based on merged cells. I have given
comments in Column G. Could you help me
sir,
Pls share update of this thread
how to convert vba to .exe
thanks in advance
On Thu, Oct 9, 2014 at 3:27 PM, Anil Gawli gawlianil8...@gmail.com wrote:
Dear Rupesh,
Pls share the file.
Warm Regards,
Gawli Anil.
On Thu, Oct 9, 2014 at 1:50 PM, Rupesh Patil patil.rupesh1...@gmail.com
Your question really leaves out too much to provide an answer... By Definition,
VBA is Visual Basic for Applications.It's Visual Basic, plus specific
objects/methods/procedures specific to the Application.VBA for Excel has things
to access things like Workbooks, Worksheets, and Cells.But it
Dear Experts,
from a long time, I am trying to create code finders list (RTO,STD,PIN)
get result from .xlam text box which search result data from another file
(ex; D drive AllCData.xlam)
but not succeed
my requirement is 1 textbox(search box) in add-in when i put value and
enter it will
dear sir
formula required in both the sheets as per mentioned in sheet 1.
--
*Rajesh Kumar Agarwal*
*9811063001*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Check this...
Add two helper column see formula in Green, i have tested for both of
sample data given by you its working..
Cheers!!
On Tue, Apr 14, 2015 at 5:39 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hello Mandeep,
Formula does not work when Column B is General Field(Mix
12 matches
Mail list logo