Solver, Macros and Range Names
I have been running a Goal Seek macro and using range
names instead of cell references. I now want to change
the goal seek macro to a Solver macro but when i record
the macro it will not let me change the macro cell
references to the range names.
Is it possible to change this?
Well, you can always make the substitution by hand. Suppose you record
SolverOk SetCell:="$B$2", MaxMinVal:=2, ValueOf:="0", ByChange:="$B
SolverAdd CellRef:="$B$1", Relation:=1, FormulaText:="0"
where B1 is named...elapsed time v. target
How can I compare an elapsed time in the format 00:00:00
against a target time in the same format, to give a time
(again in the 00:00:00 format) under or over, i.e. + or -,
the target? Excel doesn't seem to recognise a figure -
Cells >Format > Custom
In the formatted cell:
zero will appear as 00:00:00
1:2:3 will appear as 01:02:03
You can now add, subtract etc. but make sure the cells
have the selected format
>How can I compare an elapsed time in the format 00:00:00
>against a target time in the same format,...ranges in excel???
Is there any way to put a range into excel, i.e. 1 to 10,
and have it spit out data points at evenly spaced
intervals between the two numbers. (in this case, I would
put in 1-10 and excel would spit out 1,2,3,4,5,6,7,8,9,10.
one way (if you put this in cell A1): Enter the following in B1
and copy this down for as many rows as you need
> Is there any way to put a r...Range Selection for Dropdown List
Where would I find instructions for creating a dropdown list that uses a
value from another field in the record being populated e.g, if "A" is
selected is the first dropdown only entries associated with "A" display as
choice in the next list. Indirect is the function in Excel. Thanks!
Do a search on 'cascading combos'.
This is often asked.
Here's a link to a sample database
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
"S. gordon" <S. gordon@discussio...Filling range of cells with alpha-numeric text
I need an easy way to create a large number of cells with
alpha-numeric text labels such as perfa, perfb, perfc,
perfd,... perfm, etc., timea, timeb, timec, ... etc.
This works with numeric series (perf1, perf2, etc.), and
I thought Excel would allow me to fill down a series and
it would simply follow the seemingly obvious pattern. (I
could swear that previous versions did this - I am
currently using Excel 97 on a WinXP PC). If I start with
the first few entries and fill down, I just get multiple
copies of the same 2 or 3 cells that I started the fill
with. Does anyone know how t...Office trial activation
I have just bought a new laptop but when I go to the Activation
Assistant it brings up a webpage that has an HTTP Error 401.2.
I have tried looking into the problem through the Microsoft website but
it keeps asking me to go to the Internet Information Services Manager
and there is nothing on my computer with that title.
Does anyone have any idea how to get this sorted because I need to open
the Activation Assistant to get my 25 digit product key!
elli2898's Profile: htt...Macro copy range
I have this data
In column B:
In column C:
How can I create a macro that stores values from B and C column and
pastes them in column A one under the other like:
for i=2 to 3
Microsoft MVP Excel
"canvas" <email@example.com> wrote in message
i'm preparing an interforest migration and so far everything is going well
(users, groups, gpo's...)
but i have one question regarding domain local groups in my TARGET domain
(=our main one) that contain users/groups from the SOURCE domain (=the one
that will be discarded).
Is there a way to automatically re-map the old SOURCE entries to the new
TARGET entries that have been migrated?
afterwards i would also change the group into a global one. there is a two
way trust relationship between the two domains.
"dom_loc_group_XYZ@TARGET_dom" co...date range query
My job currently requires me to enter data from 300+ forms a month.
The system which we used in Excel was slow , and theprevious guy had
three workbooks for this job .
I have created a table in Access with four fields
Date Location Number of Adult Visitors Number of
I have created queries to tell me how many occurances of Location and
total and average number of visitors there are in the table and this
works fine for reporting purposes.
We keep data on a month by month basis
It has been decided that we will keep all data in a single database
from ...date range
i need a formula or help with: i have a range of dates that i need to sort to most recent date (result to a particular cell)
i an a vertual novice
Have a look in HELP index for MAX
"2little2" <firstname.lastname@example.org> wrote in message
> i need a formula or help with: i have a range of dates that i need to
sort to most recent date (result to a particular cell)
> i an a vertual novice
...Using multicell range when single cell prescribed
This is unusual (to me) range usage. It is NOT entered as array formula.
Note the results. Additional observations - you can stick dollar signs
on 1 and 10: no result change. You can (instead) copy B1 to B2: no
It's as though using a range where you "ought" to be using a single cell
[range] is interpreted as "the cell for column A of current row" (for
this choice of A1:A10).However note that B1=left(A2:A10,1) gives #VALUE.
Is this a beneficial (and reliable) tactic in some situations, for some
Is it possible to produce a top 10 using a column range across mutiple
worksheets within a workbook.
If you copy this down 10 rows you will get the 10 largest values
if there are ties they will be included (of course if there are 3 10th
values only the first will be included)
"quality831" <email@example.com> wrote in message
> Is it possible to produce a top 10 using a column range across mutiple
> worksheets within a w...Target Frame
First, thanks to this group for helping me with my
I am publishing a spreadsheet through our intranet. I am
leaving it in XLS format rather than htm because the users
need to be able to save the sheet locally.
In one column I am using the command =hyperlink (a1) to
translate a text link from SQL to a real hyperlink. That
works very well (thanks group)
BUT..... How can I set the target frame reference in the
=hyperlink column so it opens a new window? I cannot seem
to open any command to make it open a new window. When
the user clicks on the link, it prompts them to s...Active Content #2
I need a definition of Active Content??? If a custom form
used in Outlook contains active content, the message can
not be viewed in the preview screen. It is said to be a
security feature of Outlook, but I need to know why?
...Range Slider control
I'm looking for a control similar to the slider control, that allows
the user to enter a minimum and maximum value.
At this moment my users have to enter both values via simple edit
controls, but it would be much nicer if they would have a kind of
Apparently, the standard Windows/MFC Slider control is limited to
selecting 1 value, and I cannot find a way to add a second 'thumb' to
it to allow the user to select a second value.
I looked at commercial packages (CodeJock, BCG) but they also don't
have this kind of control.
I found some controls that se...looking for empty row to paste a range of copied cells
Hi - I am trying to make a code that will copy a range ("A27:L27") on sheet 1
and then look for the next empty row on sheet 2 and paste it in range
("A27:L27") . I would also like the macro to insert a new blank row (or
insert the copied row) for the purpose of shifting existing SUM functions on
sheet 2 down. I would like those functions to be right below the
copied/pasted cells every time the macro is executed.
Thanks for any help - Jim A
You don't Mention What column you want to sum
This code will copy and paste to the fist row and then sum column D
Sub Cop...How to Link named ranges from multiple Workbooks into a single Wo.
I am trying to link named ranges together from multiple spreadsheets into a
single dynamic "Master" spreadsheet.
I can link cells but wasn't sure if I can link named ranges
Preced the name with a reference to the workbook. For
>I am trying to link named ranges together from multiple
spreadsheets into a
>single dynamic "Master" spreadsheet.
>I can link cells but wasn't sure if I can link named
...Word 2007, Runtime Error code: 429, Active X component can't creat
We have office 2007 professional installed, some users are getting the
following error when opening word 2007
Runtime Error code: 429, Active X component can't create object.
When I re-create windows profile it's works fine, Is any workaround for
this, or is any easy way to just re-create offcie 2007 profile ?
...variable use in range
Regarding range() usage, I had a non-fix range value
where by "lastrow" has been assigned to a variable value
But how do I make it to function as below??
Sheets("Status").Range(Cells(1, 16), Cells(lastrow, 19)).Copy
No one can help? Basically it is to COPY from 1 worksheet to another
worksheet but I keep on getting error msg as follow:
Run-time error '1004':
Application-defined or object-defined error
Dim shtName As String
shtName = filtered
"crapit" ...1.2 Report on User activity
Is there an easy way to report on each user the number of activities
they have created?
I.E. Joe Bloggs has sent this many e-mails, had x number of phone
calls, and has created x number of appointments.
I dont want it specific to any time period, just all of them.
Thanks in advance
Have you used crystal reports before? If not might be quick to create a
Microsoft CRM MVP
"Ben" <firstname.lastname@example.org> wrote in message
news:email@example.com...Query condition by date range
I'm trying to create a query to base a report from. I need it to return
records within a date range that needs to be specified, as in specifying the
beginning date and having the current date as the end date. A field is
included in the query that has listed dates in the format mm/dd/yyyy. How
would I write the criteria? I have part of it ready - [Please enter starting
date:] . I know that's how you get the little question window.
On Tue, 4 Dec 2007 14:51:00 -0800, silva wrote:
> I'm trying to create a query to base a report from. I need it to return
> records within a...Shortcut target
Given a shortcut file (*.lnk) I need to find it's Target address.
Can some please help me out.
Am 14.04.2010 04:05, schrieb Fred:
> Given a shortcut file (*.lnk) I need to find it's Target address. Can
> some please help me out.
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>
On Apr 14, 5:05=A0am, "Fred" <repl...@newsgroup.please> wrote:
I am wanting to print a range from a spreadsheet that will
be different each time a print is req'd.
How do I set my range prior to printing?
I have tried using -
Range("A1", Range("A1").Offset(6, 19).End(xlDown)).Select
Range1 = ActiveCell
PrintArea = Range1
and variations of above, but cannot seem to nail it down.
Think I have the bones of it in there, but not sure what
else is required.
Many thanks in advance people!!
Dim myRange As String
Range("A1", Range("A1").Of...colour in a range
i have an upper and lower values in columns B and C
the user enters value in columns D to X
what i want to do is check over a range from column D to X
if any of the entered values are outside the ranges in columns B and C
i want the cell to change colour(ie Red)
if the vlaues are in sided the range i want the cell to turn green
can anyone help with Vb code for this
thanks in advance
Why not use conditional formatting, with a formula of say
(remove nothere from the email address if mailing direct)
"Kevin" <kevc...Progress to a Target
I am attempting to create a chart that measures actual progress against
On the x axis I need each month, and then a single bar that has two
series plotted with "current value" and "expected value". Basically as
each month moves by the chart would be updated to reflect progress.
How can I do this?
Kytro's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24881
View this thread: http://www.excelforum.com/showthread.php?threadid=546577