thnks rajan this is what i needed
this is really very nice of youit ease my work load...
now one more queryin attached file...sheet "gents report"cell
C2 value should get pasted in sheet "gents"...in the front of row
having staff no..
example is shown..if income tax calculatio
thnks
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Sun, Jul 3, 2011 at 12:33 PM, OpenExcel.com <26may.1...@gmail.com> wrote:
> http://openexcel.googlecode.com/files/OPEN_XL.zip
>
> Best Regards
> Ashish Jain
> http:
Hi,
FYI,
Sorry, the previously attached file already contains the macro, but its not
full proof. It is not highlighting rows 137 to 142. because its not in
sorted order.
Rash
--
--
Some important links for excel u
Paste it on Workbook code module
Private Sub Workbook_Open()
Application.StatusBar = ThisWorkbook.Path
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkatesan c
Sent: Monday, July 04, 2011 7:37 AM
To: excel-macros@googlegroups.com
Subject: R
Thanks ashish for code it helped me a lotnow i developed the code to be:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 19 And Target.Count >= 1 Then
Select Case Target.ValueCase "A"Target.EntireRow.Interior.Color = RGB(192, 192,
192)Case "C"Target.EntireRow.Interior.Colo
Event
Procedure
*Event*- An *Event* is an action initiated either by user action or by other
VBA code.
As noted above, events are generated by:
· *The Workbook *
· *The Worksheets *
· The Application (User form)
· C
'--Thisworkbook Module:--
Dim OldStaBar As String
Private Sub Workbook_Open()
OldStaBar = Application.DisplayStatusBar
Application.DisplayStatusBar = True
Application.StatusBar = ThisWorkbook.FullName
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayStat
mail your workbook to excel-macros@googlegroups.com and add file as
attachement
On Mon, Jul 4, 2011 at 2:56 AM, sswcharlie wrote:
> Hi
>
> I want to post a message with .xls file attached. Where is the button
> to add attachments to email ?
>
> Thanks
>
>
> Charlie
>
> --
>
> ---
Hi
I want to post a message with .xls file attached. Where is the button
to add attachments to email ?
Thanks
Charlie
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
Hi,
Is there a code or a build-in option to have the location path of a
workbook permanently showing on the Excel status bar?
Thanks
Pascal
--
--
Some important links for excel users:
1. Follow us on TWITTER for ti
Hello Susan,
If you just have 3 sheets, Sheet1, Sheet2 & Sheet3. use this;
=SUMPRODUCT(SUMIF(INDIRECT("'Sheet"&{1,2,3}&"'!D:D"),"C
Wagner",INDIRECT("'Sheet"&{1,2,3}&"'!E:E")))
Or,
Enter all sheet names in a range, say in J2:J3, then use this;
=SUMPRODUCT(SUMIF(INDIRECT("'"&$J$2:$J$4&"'!D:D"),
By working this function using debug. print (immediate window) and
studying the use of arrays, I was able to obtain the UDF I was hoping
to create. It takes a series of trade results (stock/futures/
options/...blackjack), such as -100, 500, 1500, -600 etc, and returns
the optimal fixed fraction of
Hi, rajan
Please can you explain event procedure ...
I have gone thr several sites but still i dont kn how to use event
procedures
Thankyou
On Sun, Jul 3, 2011 at 8:48 PM, Rajan_Verma wrote:
> Dear All,
>
> If you have any Unsolved Queries From Long time On Group , Pleas Post it
> again
Thankyou very much sir
I got it...
On Sun, Jul 3, 2011 at 4:11 PM, vijayajith VA wrote:
> HI Sir,
>
> I am unable to run the program...if i press f5 or run the program. it will
> ask
>
> "Create macro " please see the attached sheet.
>
>
> thankyou
>
> --
>
>
Hi Vikas,
Look the Below Link
http://excelvbatutor.com/vba_tutorial.html
*Best Regards,*
*Venkat*
*
*
On Sun, Jul 3, 2011 at 3:39 PM, vikas verma wrote:
>
> Hi All,
>
> I am good with excel 2007 now I want to learn VBA coding in order to create
> automation tool. Please suggest some ideas
try using conditional formatting.
On Sun, Jul 3, 201r1 at 5:45 PM, Ahmed galal wrote:
>
> Hi all,
> I need to know how to use Event Change to Change Color of Row according to
> changing in specified Column cells.
> for example:
> I have column "S" any cell in it take code A,B,C,D,R & W.
> I need
Please Read this Article
http://www.cpearson.com/excel/Events.aspx
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ahmed galal
Sent: Sunday, July 03, 2011 5:46 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to use Event Change to C
Function procedure can not be Run By F5 if they have any Arguments, they can
only return a value on worksheet and to variable.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: Sunday, July 03, 2011 4:12 PM
To: excel-macros@googlegroups.
www.akoul.blogspot.com
https://www.facebook.com/ExcelLover
https://www.facebook.com/pages/Excel-and-VBA-Codes-Macros/15180389897
https://www.facebook.com/microsoftexcel
https://www.facebook.com/l.php?u=http%3A%2F%2Fwww.excelitems.com%2F&h=014d2&;
ref=ts
http://akoul.wordpress.com/201
pls declare "I as Long" then try
On Sun, Jul 3, 2011 at 8:41 PM, Rajan_Verma wrote:
> *Please fill up this format with Some Example data so that we can help *
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mahreen Ellahi
> *
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count = 1 And Target.Column = 19 Then
Range("a" & Target.Row).Interior.Color = RGB(192, 192, 192)
Range("b" & Target.Row).Interior.Color = RGB(192, 192, 192)
Range("d" & Target.Row).Interior.Color = vbYellow
Range("c" & Target.Row).Int
workbook is not having any macro it contains UDF user defined function.
write =vrate(b1) in d1 and then drag down the formula. it work like excel
formula
if you press alt + f11 and press on module 1
you can see the code
Option Explicit
Function vRate(iResult As Integer) As Variant
Select C
Hi all,I need to know how to use Event Change to Change Color of Row according
to changing in specified Column cells.for example:I have column "S" any cell in
it take code A,B,C,D,R & W.I need when any cell change in the column "S" taken
one of the previous 6 codes, then the Row of it change
HI Sir,
I am unable to run the program...if i press f5 or run the program. it will
ask
"Create macro " please see the attached sheet.
thankyou
--
--
Some important links for excel users:
1. Follow us on TWITTER fo
try these video tutorials and websites
http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-online/
http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/
On Sun, Jul 3, 2011 at 3:39 PM, vikas verma wrote:
>
> Hi All,
>
> I am good with excel 2007 now I want to lear
Hi,
Register on the below link (FETISE) and get a instant 500/- rs off on any
purchase of the product ..its really good and once after registered please
refer to your friends and get paid and own your gifts.
http://www.fetise.com/men/register2.php?refcode=81TJ5KG0G3
Thank you
Surya
--
---
Hi All,
I am good with excel 2007 now I want to learn VBA coding in order to create
automation tool. Please suggest some ideas.
Thanks & Regards,
Vikas Verma
Bank of America
delhi.ve...@gmail.com
337199
--
--
HI Vasant
Sorry for the late reply & thanks you very much for the effort,.
Like to tell you that everything is perfect except one change need to do is
that when ever Emp taken leaves continuously like say (15th June to
23rdJune ) so when I click for output it should give me only one entry
but
Thank You All..
On Sat, Jul 2, 2011 at 10:37 AM, Brajesh Kumar Porwal <
brajeshkumarpor...@gmail.com> wrote:
> *Congratulations Ashish keep it uppp-- *
> ***
> *
> *-- *
> *--
> One Team One Dream One Goal
>
> Warm Regards,
> Brajesh Kumar Porwal
>
you are talking about *Permutation*
given number : 1 2 3 4 5
total arrangement of permutation *=FACT(5)* = *120*
==
12345 21345 31245 41235 51234
12354 21354 31254 41253 51243
12435 21435 31425 41325 51324
12453 21453 31452 41352 51342
12534 21534 31524 41523 51423
12543 21543 31542
Hi,
You can retrieve the From SQL Server by Creating a connection in Excel with
SQLServer..
Data -> Get External Data -> From Other Source -> From SQL Server
Give the Server Name and all details , Excel will Create a connection
automatically with Server and take all the Data from Select
See if it help
http://www.mrexcel.com/tip069.shtml
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of karunanithi ramaswamy
Sent: Saturday, July 02, 2011 9:29 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Urgent Help required!
http://openexcel.googlecode.com/files/OPEN_XL.zip
Best Regards
Ashish Jain
http://www.eXceLitems.com
http://www.OpenExceL.com
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and li
33 matches
Mail list logo
