I'm attempting a function that has a loop within a loop, to iterate an
optimal value. I'm not seeing why it's not calculating. It returns
#value!
On spreadsheet, the following cashflow
100
-500
1500
-600
Option Explicit
Option Base 1
Public Function OptimalF(ByVal MyCells As Double) As Double
When I do web queries and create pivot tables in Excel 2007, I really
dislike the automatic column width formattingthe columns are often
so narrow that my data is unreadable...is there a way to turn off the
auto column format function?
--
Hi Pooja,
Just watch the below link Youtube video's you may get VBA
Basic&Advancedconcepts
http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb
*Best Regards,*
*Venkat*
*
*
On Thu, Jun 30, 2011 at 10:32 PM, Pooja Sharma wrote:
> Hi All,
>
> I want to learn VBA, therefore, could an
Hi Pooja,
Just watch the below link Youtube video's you may get VBA
Basic&Advancedconcepts
*Best Regards,*
*Venkat*
*
*
On Thu, Jun 30, 2011 at 10:32 PM, Pooja Sharma wrote:
> Hi All,
>
> I want to learn VBA, therefore, could anybody suggest with a good link
> where I can learn it.
>
> --
>
thanks a lot setiyowati.devi
the files is working and its very good
regrds
LKModi
On Fri, Jul 1, 2011 at 4:59 AM, STDEV(i) wrote:
> please check the attached file, and see if it helps
>
> '-
>
> Sub ListFilesNameOfSpecifiedFolder()
>'-
Dear Venkat,
It's working, thanks a lot,
On Wed, Jun 29, 2011 at 12:06 PM, Venkatesan c wrote:
> Dear Gyana,
>
> Download the below link application and install you can remove VBA
> Password..
>
>
> *http://www.box.net/shared/eyqmr4v0sy74gonoxokj*
>
>
> *Best Regards,*
> *Venkat*
> *
> *
>
> On
Please follow this link
www.Akoul.blogspot.com
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of v_madival
Sent: Friday, July 01, 2011 1:52 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ I want to learn VBA
Pooja,
Pleas
See if it help
Private Declare Function PlaySound Lib "winmm.dll" Alias "PlaySoundA" (ByVal
lpszName As String, ByVal hModule As Long, ByVal dwFlags As Long) As Long
Private Declare Function mciExecute Lib "winmm.dll" (ByVal lpstrCommand As
String) As Long
Const SND_SYNC = &H0
Const SND_ASYNC = &H
Hi,
I'd like to know if it's possible in an Excel workbook to play a sound
when a cell's value has a condition in it while working. like :
if (A1<>0;play sound;mute)
I'm wondering this because from what I know, Excel code is running on
a user event. That woud mean, the time I'm working and the v
Hi
I have written a macro for you.
Open the attached text file and copy the procedures (everything) to VBS.
Run 'Copy_worksheets_Master' procedure.
For this to work
you need to copy all the files to a folder..
When you run the macro, it will ask you to select a folder where you stored
th
Hi
Files attached. Shipments is were the vlookup is and Database is
where the comments box are.
Oops, cannot find the place on the webpage here to attach the sheets.
Let me know how to.
Thankyou
Charlie
On Jul 1, 1:46 am, ICWAI Help wrote:
> Please attached the sheet.
> so we can help you
Pooja,
Please let me know if you get any link. I also want to learn VBA.
From: "Pooja Sharma"vatspoojav...@gmail.com
Sent: Thu, 30 Jun 2011 22:56:56 +0530
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ I want to learn VBA
Hi All,I want to learn VBA, therefore, could anybody
Please attached the sheet or file we could help u then
On Thu, Jun 30, 2011 at 9:50 PM, crossy75 wrote:
> Hello again - and thanks for the last response, you guys are ace!
>
> right have now taken a lot of data relating to clients and have a
> pivot table, which when i show pages lists 30 worksh
Hi*,*
** **
This is *Sandeep *from *Magna InfoTech.*
* *
This is regarding an Urgent Opening for *Data Analyst / MIS Executive. *I
find your profile suitable for the requirement; if you are interested,
kindly send me your updated CV at the earliest. If you are through all the
selection rou
Please use below link to learn VBA
http://www.ozgrid.com/Excel/free-training/ExcelVBA1/
http://www.cpearson.com/excel/MainPage.aspx
http://www.discussexcel.com/learn-macros
http://www.fontstuff.com/vba/index.htm
http://akoul.blogspot.com
http://www.vbtutor.net/
http://www.xlmacros.com/
http://www.
Hi All,
I want to learn VBA, therefore, could anybody suggest with a good link where
I can learn it.
--
*Best Regards
Pooja Sharma*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips trick
Hello again - and thanks for the last response, you guys are ace!
right have now taken a lot of data relating to clients and have a
pivot table, which when i show pages lists 30 worksheets with each one
being a separate client and valuation.
Is there a way instead of showing the pages as individu
>
> Can u please help me in writing a macro in excel as below:
>
> 1) When we click on the command button, it should prompt for entering
> the employee number in the input box.
>
> 2) After entering the employee number, it should take us to the cell that
> has
> the number.
>
> 3) and corresponding
Can u please help me in writing a macro in excel as below:
1) When we click on the command button, it should prompt for entering
the number in the input box.
2) After entering the number, it should take us to the cell that has
the numer.
3) and coresponding cell should be filled with current tim
*="$"&ROUND(B3/1000,0)&" "&"GMRR"&""&"("&ROUND(D3,2)&"%"&""&"of the Plan)"*
*find the attached file and formula it will works .
*
On Thu, Jun 30, 2011 at 5:58 PM, Monu Tiwari wrote:
> Awesome . thanks everyone !
>
>
> On Thu, Jun 30, 2011 at 3:14 PM, ankur wrote:
>
>> hi ak
>> file is attached f
Please attached the sheet.
so we can help you better
On Thu, Jun 30, 2011 at 6:29 AM, sswcharlie wrote:
> Hi
>
> Have a photo in a comments box in wb 2. Also have a vlookup in
> another workbook WB1 to bring forward the text from the cell into
> WB2. This works great. I also want to bring fo
Awesome . thanks everyone !
On Thu, Jun 30, 2011 at 3:14 PM, ankur wrote:
> hi ak
> file is attached for reference
> 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 Thu, Jun 30, 2011 at 3:10 PM, ankur
Dear Ankur Padey Sir How are you?
On Thu, Jun 30, 2011 at 4:12 PM, ankur wrote:
> hi gilberto
> your file is undownloadable
> 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 Mon, Jun 20
Check this link
http://www.ozgrid.com/forum/showthread.php?t=66389&page=1
On Thu, Jun 30, 2011 at 1:40 PM, L.K. Modi wrote:
> Dear GroupMembers,
>
> I want to list the file name that are in closed folder .Means any way by
> which i can get the files or workboooks name that are in a particular
>
hi gilberto
your file is undownloadable
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 Mon, Jun 20, 2011 at 10:44 PM, Gilberto wrote:
>
--
---
hi kashan
your sample data will be required for ad hoc solution
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, Jun 26, 2011 at 11:41 AM, Dilip Pandey wrote:
> Hi Kashan,
>
> You can use following formula in col
hi ak
file is attached for reference
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 Thu, Jun 30, 2011 at 3:10 PM, ankur wrote:
> hi AK , use this formula, may it fullfill ur requirement use in F3 cell
> =TEXT((C3
hi AK , use this formula, may it fullfill ur requirement use in F3 cell
=TEXT((C3/1000),"$#,#00")&"K"&" GMRR ("&ROUND((E3*100),0)&" % of the plan)"
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 Thu, Jun 30, 2011
Dear GroupMembers,
I want to list the file name that are in closed folder .Means any way by
which i can get the files or workboooks name that are in a particular
folder.
Thanks in advance
Regards
LKModi
--
--
S
Atul,
Please use below coding it will help you to delete the blank cell of column A.
Sub Macro6()
Columns("A:A").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.Delete Shift:=xlUp
End Sub
Regards,
Shrinivas
Citi(r) Global Transaction Services - India
UB City, Canberr
Hi Ak,
Find attached your query resolved
*Best Regards,*
*Venkat*
On Thu, Jun 30, 2011 at 1:10 AM, Monu Tiwari wrote:
> Hi Experts,
>
>
>
> I want to concatenate the different cells without losing the format of the
> cells. Please refer the excel sheet for more details.
>
> Thanking you
Thank you so much Santos it worked perfectly and you are a champion
keep up the good work mate...
Regards
Chris
On Thu, Jun 30, 2011 at 10:15 AM, santosh bahuguna <
santoshbahug...@gmail.com> wrote:
>
> use this
>
>
> If (Target.Column <> 3) And (Target.Column <> 4) Then
>
> Please find t
Thank you very much santhosh. Is it possible to make an .exe file in excel
so that no one can see the code behind and they just open it and use without
opening the excel sheet.
--
--
Some important links for excel
33 matches
Mail list logo