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 mu
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 yo
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 rngActi
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" wrote:
> Press CTRL+G Goto Special Choose Blanks ,
>
> It will select all Blank cell then Press 0 and Ctrl + Enter
>
> From: excel-macros@googlegroup
Rajan,
Your solution is awesome!!!
On Aug 19, 9:39 am, "Rajan_Verma" 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
>
> Range("F9").Resize(1, Rang
See if the link below helps:
http://www.contextures.com/xluserform02.html
On Aug 12, 9:07 am, "dguillett1" wrote:
> Pls ignore previous post. I sent the wrong file
> Change to vertical>remove all merged cells>use autofilter with SUBTOTAL(109
> function
>
> From: Dominic Sundar
> Sent: Thursday,
I think a "One point lesson" on this add in would be highly welcome.
Thanks
On Aug 8, 10:27 am, Anil Bhange
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 Phone - 512320 | Mobile -
the password in vba code
>
> Sub Macro1()
> ActiveWorkbook.Unprotect Password:="xxx"
> Sheets("*Sheet1*").Visible = False
> ActiveWorkbook.Protect Structure:=True, Password:="xxx"
> End Sub
>
> On Tue, Jul 26, 2011 at 8:44 AM, mah
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 @ http://www.linkedin.com/grou
Congratulations Ashish!!
His posts motivated me to learn more And I've learned a lot.
Thanks
On Feb 2, 9:55 am, Ayush 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 2011 and helped
>
11 matches
Mail list logo
