Hi Everyone,
I need some help with this formula problem I'm working on, so if you
have any free time you can help me solve it would be great.
Tab #4 on the attached spreadsheet is the closest I have for the
formula to work. Essentially colums A to H are used to calculate how
much rent the tena
It's really going to depend on what you're doing.
Initially, it seems that you're wasting effort.
You're:
1) defining a range,
2) copying the range values into an array,
3) processing the array.
why not simply process the range values?
at the same time, it may require more cpu cycles to compa
Thanks. All that I'm using the array for is to go through a loop, and
for each value in the array, to do particular things to particular
tabs (which are determined solely by the array values). I found out
what was causing me problems: my xlLastCol function was not working,
and returning a last colu
Hi Group,
No success with the problem yet. Anyone else care to take a stab at it ?
Thanks.
On May 26, 2010 10:06pm, Bill Q wrote:
Thanks for the effort Saggi. It is appreciated.
Unfortunatly, it seems that I am guilty of not being specific
enough.Here is what I need step by step:
Thanks a lot KAMAL !!!
your solution works fine, but, It would be possible to obtain
the same result with a dynamic graph ?
I'm testing that solution with de MouveMove event of a shape :
like that : http://cjoint.com/data/fFrTGZSr2t.htm
Do you think is it possible tu activate visibility (true or
in order to give you a recommendation that has any value,
I need to know what you plan to do with the array.
Your example indicates that you want to create an array
and populate it with the contents? of a range consisting of all cells with
values.
Of course, when more data is added, the array siz
Dear Group,
Can i have UNIQUEIFS Function its some thing like SUMIFS
Best Regards,
*
Venkat
*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/e
This should give you something to start with:
Option Explicit
Sub OpenFiles()
Dim fso, fl, fc, f
Dim PathFldr
Dim msg
Set fso = CreateObject("Scripting.FileSystemObject")
PathFldr = "C:\temp"
msg = "Selected:"
If (fso.folderexists(PathFldr)) Then
If (Right(PathFldr, 1) <> "\") Then PathFldr = Path
im trying to create a commandbar menu object for worksheet with a
dropdown submenu which can count number and names of worksheets in any
active workbook.
the code i've written is as given bolow, it is not working?? dont know
why?? is there anybody who can help me with it
Sub myusershowmenu2()
Dim
Dear All
Please help on below
I want macro in worksheet like *If range a1 value is >1 then entire row
(with formulas in row)should be copied to next row until column cell value
= 0*
* *
Thanks
Rajesh
--
I need to make a macro to open files whose name start with
Extract...the Folder has about 15 files and about 10 files begin with
"extract". I think i need a loop to do it but dont know how to do
it.plz help
--
---
You Can use Mailmerge
On Thu, May 27, 2010 at 3:23 PM, vibs wrote:
> Dear Members,
>
> I have to send the emails using Microsoft Outlook to multiple users
> individually (And not to all of them in one go) with their respective
> records. For example,
>
> Users Pending transactions Email id
>
Thanks for your reply but can you solve my query with formulas. Because I
don't know any thing about Macros how to use it or where to insert macro
code. Your reply will highly appriaciated.
Regards,
Aamir Shahzad
On Sun, May 30, 2010 at 10:20 PM, Mahesh parab wrote:
> Hi Aamir
> i herewith att
Thanx Swapnil!!!
Its working
On Thu, Jun 3, 2010 at 10:05 AM, Swapnil Palande wrote:
> Hi Deepak,
>
> Save you excel as "Microsoft Office Excel Add-In". After saving excel as
> add-in, you will get access to macros of this excel in all other excels. You
> can add your own menu in menu bar.
> If y
Dear All,
I urgent need Ms-Excel,MS Access & SQL
Interview Tips. kindly send all tips for the *MIS position.* If have any
opening in MIS please guide.
Thanks,
Prabhakar Thakur
New Delhi
+919953736776
--
Thanks it works now
Good Tricks
Have a nice time
Savla
On Wed, Jun 2, 2010 at 8:43 PM, sudhir kumar wrote:
> there is a problem of formatting in that file,
> what u can do is just copy the entire data, and past it to another file,as
> a match destination formating, after that ur cu
Thanks for yor help Stuart.
Regards Don
On Jun 2, 2:27 pm, Stuart Redmann wrote:
> On 1 Jun., 01:57, donvreug wrote:
>
> > The environment this is occuring in is a corporate one where there are
> > a number of Excel workbooks each with VBA modules that are deisgned
> > for different tasks. Oc
17 matches
Mail list logo
