Hi
PFA
Pl let the code be in separate module & not in sheet module.
I had mapped last row on Col A due to which you might not be getting result
on all Rows..
Cheers!!
On Mon, Jun 30, 2014 at 8:32 PM, jun a wrote:
> Dear Vabz,
>
> Apology for the late response, as i was trying to solve some
Dear Bé Trần Văn
Code is good but required data sort each column but code sort data on
basis of D7 cell only ,if i want sort it another column then need to
change cell numbers each time then work done in some time.
Can we give as header row No 6 as ascending & descending then we can
sort data with
Dear lalitji
code not working
On Tue, Jul 1, 2014 at 8:00 AM, Lalit Mohan Pandey
wrote:
> I have checked it and it is working fine but give a try to this code:
>
> Sub SECEPSDES()
>
> With ThisWorkbook.Worksheets("Sector Valn")
> .Sort.SortFields.Clear
> .Range("A6:U21").Sort
I have checked it and it is working fine but give a try to this code:
*Sub SECEPSDES()*
*With ThisWorkbook.Worksheets("Sector Valn")*
*.Sort.SortFields.Clear*
*.Range("A6:U21").Sort Key1:=.Range("E7:E21"),
Order1:=xlDescending, Header:=xlYes*
*End With*
*End Sub*
To use the code for another sheet, you add 2 lines of code on the start and
end Module.
With ActiveWorkbook.Worksheets("Sheet1")
End With
Sheet1 is the name you need to reference sheet.
For example:
Sub SortAscendingD_Sheet1()
With ActiveWorkbook.Worksheets("Sheet1")
Rows("7:2000").Select
PFA
It might help you.
On Mon, Jun 30, 2014 at 4:17 AM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
> Dear Sir / Madam,
>
> Please see the attachment. There could be thousand clients with their
> banks. I want wnen I put the client name in the column a, there will be
> dropdown lis
Dear Vabz,
Apology for the late response, as i was trying to solve some issues with
the code by myself, but sadly i did not get very far.
The logic is great but the macro only seems to works on that sample_input
worksheet, as I tried to copy the macro onto new worksheet (please see the
new a
my first suspicion is that your 2010 application hasn't been set to "trust the
VBA object model".
Because just about everything in 2007 is available in 2010.
but your error seems to imply a permission to create a userform object.
for which you would need to VBA trust setting set.
Look at:
F
Thank you sir, will create button as per your suggestion.
2014-06-29 20:32 GMT+05:30 Vaibhav Joshi :
> Hi
>
> You can create a button on main sheet to run macro. Create button or image
> and right click on it to assign macro.
>
> Cheers
> On Jun 29, 2014 5:43 PM, "Vijayendra Rao"
> wrote:
>
>>
*Hello Friends and All Group Member Please Introduce your self.*
Hello Sir/Ma'am,
My name is Satendra Kumar basically i belong from Aligarh Uttar Pradesh but
currently stay at Noida sector 15.
I am postgraduate in MIS (management information systems) from Sikkim
Manipal University in 2014.
*Ex
Dear Sir / Madam,
Please see the attachment. There could be thousand clients with their
banks. I want wnen I put the client name in the column a, there will be
dropdown list in the column B. All the bank name will be shown in the
dropdown list of correspondence client name
Thanking you in Adva
11 matches
Mail list logo
