Hi.
In the macro above, cell A6 would be listed as:
.Cells(6,1)
Cell A1 would be shown as:
.Cells(1,1)
To keep the macro as it is but have it not sort rows before row 6 you
should change the code sections as follows:
'Set up an index column of ascending numbers after the last column
Hi,
I have a very large large spreadsheet with 2 rows and about 50
columns most with long complex formulas so calculation on this sheet
takes time. The main purpose of my code is to perform a Goal Seek but
depending on results the code might loop up to 100 times. Each Goal
Seek takes about 9
Hi,
Can't you just set calculations to manual while you do the Goal Seek?
Dave.
Date: Fri, 11 Sep 2009 03:33:04 -0700
Subject: $$Excel-Macros$$ VBA - Access multiple Excel instances
From: paul...@gmail.com
To: excel-macros@googlegroups.com
Hi,
I have a very large large spreadsheet
Hi Mullan,
Try the following code:
Sub DKP()
Dim ws As Worksheet
For Each ws In Sheets
If ws.Visible Then ws.Select (False)
Next
Range(a12).Select
Selection.FormulaR1C1 = dilip kumar pandey
End Sub
' replace the text which you want to type with dilip kumar pandey in the
above code.
--
Hi Dhananjay,
I think you have missed this one. In this I have already provided a revised
solution to Vijay. Thanks.
==
===
-- Forwarded message --
Hi Subu,
Attached workbook contains the scenario mentioned by you + the required
automation. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/7/09, Subu mail_to_s...@yahoo.com wrote:
Hi
I
Below code may help u
*Sub um()*
*If Application.Wait(Now + TimeValue(0:00:10)) Then*
*MsgBox Time expired ' or write Unload Me here*
*End If*
*End Sub*
Thanks Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Fri, Sep 11, 2009 at 10:23 AM, suresh k brave.sur...@gmail.com
Hi Dave,
In a way that was my problem, dispite the fact that I had calculation
set to manual the sheet with the large large table was still
recalculating at each iteration! I've managed to get around it by
explicitly turning off calculation on that sheet during the goal seek
using
Thanks a ton
Regards
Subu
On Sep 9, 7:56 am, Ashish Jain 26may.1...@gmail.com wrote:
Hi Subu,
1. Close all excel applications.
2. Go to this folder - C:\Documents and Settings\Your User Name
\Application Data\Microsoft\AddIns
3. Delete the file(add-in) from here.
4. Re-open Excel and
hi,
Pls find the attached sheet
I want to put suffix/ prefix in the require cell
Regards
Manoj
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient, please
notify
I am member of an group of professionals
They have created a website allowing members to have access to certain area
of website.
I also have such user id password where in I can log in and view
restricted data
One of the contents in restricted area is list of members with their contact
Dear all,
Can anybody describe with example the difference between sumif sumifs?
Regards,
Aamir Shahzad
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and
Dear All
in attach sheet i want to find latest value of column B (i.e Prod Type) from
Sheet2,
i use below mention formula to find latest value for column A
=LOOKUP(2,1/('Main Data '!A18:A25=Sheet1!A19),'Main Data '!D18:D25)
--~--~-~--~~~---~--~~
Hi Everyone,
I am a newbie. Please be patient with me. OK. Here is what I want
to do.
I have a bunch of small macros that use the following code.
The only difference when the code runs in the different small
submacros is that in the statement:
Range(C CStr(LCurSRow)).Formula =
Hello all I am new to this group and was wondering if you could help
me with custom formatting of cells.
I have a long set of 1000+ t1 locations and they all are in this
format
vt1-1-a-1-1-1-5
vt1-1-b-3-5-6-1
vt1-3-b-4-5-1-2
etc.
Id like the custom formatting to fill the hyphens and the vt1
Hi, I am looking for some help on this! I have an Excel file with a
Pivot Table, using as source of information another tab stored in the
same file. Now, I use the Show Pages. Works perfect. I have the macro
to export each new tab to a separate Excel file. Works perfect, but
each new tab still
Hi Everyone,
I am a begineer with VBA. I need some help. Sample data is shown
below. Column A is a list of employee names. The TBD person
represents a new hire that will be hired sometime in the future.
Columns AR and beyond are months years. For example, row 1 column AR
is Sept -09. Row
Hi Everyone,
Thanks for the help on my last question. I would like to expand on
that macro slightly. I have tried a couple of things and they are not
working.
Here's what I would like to do. Sample data is shown below.
1). I would like to keep the duplicate TBD that are shown in Column
A.
Hi Dilip,
Please find enclosed herewith the Query file which is revised on your
solution to vijay Kumar vijaykumar...@gmail.com
On 9/1/09, Dilip Pandey dilipan...@gmail.com wrote:
Hi Vidyut,
Attached workbook has the solution for your query. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B
Well Done Sandeep and Bruno !! Both of you done it very well.
If I've to rank between Bruno and Sandeep, you will be ranked higher
than Sandeep for your fantastic presentation. I appreciate efforts of
both of you, and agree that this was much harder than previous ones.
But both of you
Forget it, solved! Just need to uncheck the option Save data with
table layout in the PivotTable options...
Thanks anyway!
Chechu
On Sep 11, 3:23 pm, Chechu cecic...@hotmail.com wrote:
Hi, I am looking for some help on this! I have an Excel file with a
Pivot Table, using as source of
Hi Aamir
Please check out - Hope it helps !
http://www.excelitems.com/2009/09/difference-between-sumif-and-sumifs.html
--
Thanks Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
22 matches
Mail list logo