Way do do search/replace on beginning/end of cell w/o functions?
Hi, I've been writing various functions to search/replace beginning/ends of
cells, however wondering if there is a way to do the simpler ones with just
In word I'd just do
but not sure if there is a symbol I can use to mean beginning/end of cell.
For instance I want to replace all Cells with
but not where
* Board Certified
I can of course write a function but the sheet is unwieldy as it is and it
is a simple 'request'...
for a begin/end cells replacement, try first with a cust...Selecting part of a filed
I have table with a field like this one and I need to separate the dollar
amount out, the amoount can range from 3 digit to 6 digit or more.
XY4567 Converter belt $3.40 or 7890 Transmission $1250.00, I need to develope
a query to extract the dollar amounts or cost
Message posted via AccessMonster.com
val( Mid(fieldName, 1+InStr(fieldName & "$" , "$")))
Hoping it may help,
Vanderghast, Access MVP
"CharlesCount via AccessMonster.com" <u35616@uwe> wrote in message...zeroing down stock value
does anyone know how to zero the stock value, leaving all sales history and
or information intact.
Anyone using RR multi location
Let me know and email me what question you have on RR Multi Location.
Afshin Alikhani - email@example.com
= = = = = = = = = = = = =
"Andaiye" <Andaiye@discussions.microsoft.com> wrote in message
> does anyone know how to zero the stock value, leaving all sales history
> or information intact.
> Anyone using RR multi location
If you want to z...How to Update Selections for (Numerous) Validation Lists
Dear Excel Experts:
I have many validation lists which source can change frequently. How do I
automatically update the validation lists every time the sources change?
I got some lead from www.contextures.com (see below). But, it only helps
when I have one validation list. Meanwhile, I have many lists.
DV0022 - Update Validation Selections -- If you change an item in a data
validation source list, the worksheet may show previously selected items.
Event code can update the worksheet when you update the source list.
DataValUpdate.zip 10kb Updated 07-Sep-11
Thanks in advanc...deleting random amounts of data from user selected columns..
I need help! I cannot seem to figure out the best way to modify a
worksheet in excel. I have a worksheet with 38 col's, and 47 rows of
data. I need to allow the user to select one or more columns, then
remove a random number cells from the selected columns. Any ideas????
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
This should get you started
Dim iNumber As Integer, iLoop As Integer
Dim lRow As Long, iCol As Integer
iNumber = Int((Selection.Columns.Count * Rnd) + 1)
...Insert string into a Cell ?
How do I insert string into a cell ?
Dim myString As string
myString = "abcd"
shp.CellsSRC(visSectionProp, visRowProp, visCustPropsValue) = myString
'This will yield with type mismatch error.
You've got a reference to the cell but not the property of the cell object.
So if you want to set the cell's formula you need to use that property.
Also, as you're adding a string you need to wrap it up in quotes (note two
double quotes in a row get evaluated as a single set of quotes).
Have a go with the following:
shp.CellsSRC(visSectionProp, ...DPM2010RC, Does selecting Bare Metal Recovery cover everything I n
Or do I need to also select System State and/or the Volumes on the system?
What all do I need to be able to recreate a system from scratch and have it
exactly like it was before?
I would also like to add to this. What Operating Systems does BMR support?
Client OS such as XP,Vista, and 7?
"Daniel Segel" wrote:
> Or do I need to also select System State and/or the Volumes on the system?
> What all do I need to be able to recreate a system from scratch and have it
> exactly like it was before?
BMR is supported only for WIN2K8 and WIN2K8 R...Selecting a Drawing Object
I need to get the name of a drawing object when I click it via a left click,
I need to assign it to a variable. Any help would be greatly appreciated.
Dim myShape as shape
set myshape = activesheet.shapes(application.caller)
'just to show a few ways to get it and other options
msgbox application.caller _
& vblf & myshape.name _
& vblf & myshape.topleftcell.address
Troubled User wrote:
> I n...I want to bold selected text, entire document is bolded?
I'm working in Word. When I highlight a section of text to be bolded,
italicized, etc. the entire document gets bolded italicized, etc. How do I
stop that from happening?
Might try a Word group...
Mary Sauer MSFT MVP
"Seeker" <Seeker@discussions.microsoft.com> wrote in message
> I'm working in Word. When I highlight a section of text to be bolded,
> italicized, etc. the entire document gets bolded italicized, etc. ...Return to cell whose address is stored in different cell
Hi.. Thanks for your help!
I am writing a macro in Visual Basic.
I need to Select a Range from first Cell within the Range, copy the
Range, paste the Range to a location with formulas so I can edit it,
then copy the edited version of the Range and paste it back to it's
orgional location (probably by using the first Cell selected).
I've tried previous property, source range and afew other things that I
couldn't make work.
Got any Ideas????
spydor's Profile: http://www.excelforum.com/member...swap axes
In a line chart, Excel seems to predetermine the category axis - how can I
swap this so that my Y-value axis appears along the bottom?
Have a look at Jon Peltier's page
> In a line chart, Excel seems to predetermine the category axis - how can I
> swap this so that my Y-value axis appears along the bottom?
Andy Pope, Microsoft MVP - Excel
I've got the same problem as Fridgemaster. Andy, good try, but your solution
is not what we are asking. Prima...controlling active cell
I have a spreadsheet with 4 columns. I am scanning some bar codes
into the 2nd and the 3rd column. I want to the active cell to change
to the 3rd cell after I scan the bar code for the second column. This
is obviously easy to do. But I want it go to the 2nd column of the
next line after I scan the bar code for the 3rd column. Is there any
way to do this?
Description Tag # Serial # Pallet
Description Tag # Serial # Pallet
my table has columns with formulas. some of the rows are
blank. the formulas do not apply to the blank rows. in
some of the colums, in blank cells a zero prints and in
other columns a $ sign prints in empty cells , and others
get "#value!" while some remain empty.
my question is this - if there is no data, I would like
the cells to remain blank. how do I accomplish this?
"rudy" <firstname.lastname@example.org> a �crit dans le message de
> my table has columns with formulas. some of the rows are
>...Swapping cells on linked spreadsheets
I have 2 spreadasheets. The fist one is named "Name and Bed Entry". On this
spreadsheet the user literally types in a name as it relates to a bed (or
room number) and other info. The name and room number is then linked to
another spreadsheet called Master Resident Info. This spreadsheet has the
cost of that room. So, in Master Resident Info, the name entry actually
looks like ... =IF('[Name & Bed Entry test.xls]Name Entry'!$B$52="","",'[Name
& Bed Entry test.xls]Name Entry'!$B$52). The cost of the room in Master
Resident...Hlookup with Merged cell as look up value
Hopefully someone can help me out on this one. I have a spreadsheet that
looks similar to this:
2/15/2010 3/15/2010 . . .
Site# INV VALUE INV VALUE
1 34 332 40 440
2 47 250 47 250
3 55 476 36 420
Total 136 1058 123 1100
I am trying to use a Hlookup to return both the Totals for both the INV and
Value in a compainon sheet. The date cells are merged over the INV and VAL
Colums so my Hlookup fo...Comparing Repeating Cells
How do you express a formula for the following examples
If A2, B2 and C2 all cells with same numbers as A1, B1 and C1,
in any order, then D1 equals 3, (ie 3,,7,,2 followed by 3,,2,,7)
If A2, B2 and C2 have only 2 cells which is the same as A1, B1 and C1,
in any order, then D1 equals 2,
(ie 3,,7,,2 followed by 2,,3,,4) or (ie 3,,7,,2 followed by 3,,7,,7)
If A2, B2 and C2 have only 1 cell which is the same as A1, B1 and C1,
in any order, then D1 equals 1,
(ie 3,,7,,2 followed by 0,,2,,4) or (ie 3,,7,,2 followed by 3,,3,,8)
or ie 3,,7,,2 followed by 2,,2,,2
If A2, B2 and C2 have n...Protecting formulas in cells
I need to know how to protect only the cells that have a
formula in them, and still allow editing of other cells.
You can select special ranges by:
ctrl-A to select the whole sheet
click on Formulas (or constants or blanks)
Now you've just selected all the formulas (or constants or blanks).
Check Locked or uncheck Locked (depending on what you selected)
Now protect the worksheet. Tools|Protection|protect sheet.
Depending on how many cells I want different, I'll select everything and unlock
them. Then come back and lock ju...SQL Select Problem
I have a little problem with a select.
I would need to have the most simple solution :-)
I have the following table:
[FK_Candidate], [Key], [Value]
1 'Profession' 'Informatiker'
2 'Profession' 'Informatiker'
1 'Source' 'Quelle1'
2 'Source' 'Quelle2'
I need to get all candidates with
Profession = Informatiker AND Source =...strange cell format
Everytime when I create a new excel file, all cells are
divided by 10. when I type in a 1 then the cell's value is
what is even worse: every formula is reduced to a zer!
please help me out here!
Click Tools > Options > Edit tab
Uncheck "Fixed Decimals" > OK
"umbro" <email@example.com> wrote in message
> Everytime when I create a new excel file, all cells are
> divided by 10. when I type in a 1 then the cell's value is
> what is even worse: every formul...assign a wav sound to a cell value
how do I assign a wav sound to a cell value?
I have a column with OR statements. when a cell in that column turns
TRUE, I want to hear a wav sound.
how can I do this?
...Selection within a named range
There is a named range "Rng" in my workbook. I want to write a VBA
program to select the first 10 rows of the range "Rng". What code should I
I don't know how you could do this, but you could create another named range
consisting of the area you want.
"Andy Chan" <firstname.lastname@example.org> wrote in message
> Dear all,
> There is a named range "Rng" in my workbook. I want to write a VBA
> program to select the first 10 rows of th...Changing the order of a name in various cells
I have a column with over 400 rows of names that most contain names reading last name first then a comma then a persons first name. Such as Sullivan, Mike. How can I change the order to read first name then last name without the comma? Such as Mike Sullivan.
Thank you for looking.
With entry in A1:
=RIGHT(A1,LEN(A1)-FIND(",",A1)-1) & " " & LEFT(A1,FIND(",",A1)-1)
(Don't use my reply address - it's spam-trap)
"happydude" <email@example.com> wrote in message
news:9...Excel should allow you to swap rows. Also swap columns
This is a general feature request for Excel.
It would be great if I could select 2 rows (using ctrl + click). Right-click
on one of those rows and have a menu choice called Swap.
Example: assume that I have selected row 2 and row 4,
...How to select multi-user ???
For example, peter & john's email account are installed in the same post
office or identity(I don't know how to say in outlook), when I compose new
email, I can select the sender is peter or john in outlook express, but in
outlook, no selection can be provided.
HOW TO DO IT ???
Appreciate for any advice !!!
jj <firstname.lastname@example.org> wrote:
> For example, peter & john's email account are installed in the same
> post office or identity(I don't know how to say in outlook), when I
> compose new email, I can select the sender is peter or john in...change info in 1 cell, prompts you for another
I would like to have a promt or some type of notice that when a user changes
the information in cell B15 that it might be necessary to change the
information in B25.
Ideally, I would want a popup box/notice that says "You've changed the
information within, would you like to change XX as well?"
Realistically, I would settle for a simple change in cell colour or
something similar to indicate that more changes may be needed.
Does anyone have any ideas? Thanks!
Hi, it's very simple, you should select the cell that you want to hav
the pop up, then go to Data >> Vali...