De Premor,
I like your solution.
This is an opportunity for me to learn new tips and polish my VBA skills. I
will attempt to combine yours and Paul's;
Next step would be to try to 'merge' my userforms.
Instead of having 1 userform for data entry and another for search,I am
thinking of using:
a
Paul,
I've started learning VBA , but I took some Python PHP classes .
I would really like to see your original solution. I like the way to
explaining stuff. Your solution will definitely be very helpful in my
learning process.
BTW, I am following all your posts and I've learned a lots from
Wow .you guys are great!!!
I've stumbled upon a sorting code at :
www.clearlyandsimply.com/clearly_and_simply/2011/05/sort-excel-tables-by-double-clicking.html
Here is the code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
Dim rngTable As Range
Dim
Rajan's solution is simple, easy and I like it bestbut it does not
address the need for formula as requested.
On Aug 26, 6:21 am, Rajan_Verma rajanverma1...@gmail.com wrote:
Press CTRL+G Goto Special Choose Blanks ,
It will select all Blank cell then Press 0 and Ctrl + Enter
From:
Rajan,
Your solution is awesome!!!
On Aug 19, 9:39 am, Rajan_Verma rajanverma1...@gmail.com wrote:
You Can Tri this :
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Err:
Dim k As Integer
If Target = Range(H7) Then
Application.EnableEvents = False
See if the link below helps:
http://www.contextures.com/xluserform02.html
On Aug 12, 9:07 am, dguillett1 dguille...@gmail.com wrote:
Pls ignore previous post. I sent the wrong file
Change to verticalremove all merged cellsuse autofilter with SUBTOTAL(109
function
From: Dominic Sundar
Sent:
I think a One point lesson on this add in would be highly welcome.
Thanks
On Aug 8, 10:27 am, Anil Bhange anil.bha...@tatacommunications.com
wrote:
Hi Rajan,
Still I am not able to do with this addin, find below screen preview
[cid:image001@01CC5605.69E40C40]
Regards, Anil Bhange
IP
I have a workbook with 3 sheets 2 of the sheets are for general use
but one
of the sheets i would like people to access only by a password is this
possible? i can protect the sheet but i would like only certain people
to
view the information? protecting stops people from amending/entering
data.
See attached file if it helps
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
Congratulations Ashish!!
His posts motivated me to learn more And I've learned a lot.
Thanks
On Feb 2, 9:55 am, Ayush jainayus...@gmail.com wrote:
Ashish Koul has been selected as *'Most Helpful Member'* for the month of
Jan 2011.
He has posted over 75 posts (11% of total posts) in January
10 matches
Mail list logo
