Posts by imported_Anonymous

HI

Insert your shape and right click on it. You should get a drop down menu from which you choose format autoshape. Then choose the co;ours and lines menu. In the dropdown box labelled colour select FillEffects>Picture>Select Picture. Now browse for your picture. Double click on your picture and click OK. That's it

I tried the suggestion but it still doesn't work. A value of 1.70% on the spreadsheet is merging over into the Word document at 1.7000000000000001E-2

Thank you for trying to help.
Pam

Goodmorning Dreamboat and thank you for taking the time to respond. I understand about the confidentiality. It's at least a start that you've confirmed this is feasiable...or is that plausable? Regardless, you've given me hope to continue searching.

Have a great day. I'm also from the chilly state of PA.
Thank you,
Pam

How do I create the break even point in excel??? Thank-you!!!

It did! Thanks Chris!!!:guitar:

I wish to add 2 lots of option button to a worksheet.

The first set of 3 options are all related together and share the same cell link in Format Control

However I wish to add a second unrelated set of option buttons but whenever I add another they are related automatically linked to the first set of option buttons and throw out the option values.

Is it possible to have 2 sets of independent option buttons or must I add then via VBA

Need to create a pricing model, whereby the back sheets contain the chemicals, prices, formulas and calculations.
The front sheet enables user to modify chemical proces and have new compound cost calculated on front sheet.
Workbook, sheet passwords are trivial to break.
How can we create a secure model so the formula sheets can not be accessed?

I have a spreadsheet created by pulling info in using VBA. The spreadsheet has percentage values inside a cell. When I merge them into a word doc report, the percentages are carried over incorretly.

Example: 1.5% may carry over to the report as .0000000001.5-E1 or something to that effect. How can I correct?
Thank you

Question: I have a folder in which I've placed 10 letters created and formatted with necessary merge criteria.

I have a spreadsheet which strores all the information needed for the various letters.

Can a program be developed to look at the spreadsheet, identify the letter needed (name of letter in first column), open the word document to merge onto and automatically merge and print? This would need to be repeated for every letter on the spreadsheet (these 10 letters may be called for 100+ times).

If there is a way to do this, is it something the "simple" mind can understand and accomplish? I'm just knowledgeable enough to be dangerous.

Thank you to anyone who can help.
Pamela

Hi,

Yes I have a workbook opened in the other excel application instance.

Thanks
Sri

I am attaching a Time Sheet that I have just completed for work, it automatically highlights Sat & Sun when the month is changed . I used Conditional format, the Weekday function and a Lookup.
There are some macros in it, but they are irrelevant to the weekend highlighting.

Hi Guys,

Need help.

Let us say I have my data in sheet1 and on sheet 2, i'd like to have a "combo box" with different items in it. How do i add entries in the combo box and how can be able to show different graphs depending on the item chosen in the combo box?

Thanks a bunch.

Gman

Hello All,

How do one activate the other active excel application from an already active excel application. Suppose I've started two excel and from one excel thru a macro how do I activate the other Excel Application.

Many A Thanks
Sri

I have developed a spreadsheet model that uses macros and VBA and plan to send it our to my clients.

For those who have set Macro Security to High is there any way I can automatcially change their settings to avoid countless phone calls of the model not working.

Obviously the documentation will specify that the Macro Security must be set to Medium in order for the model to work.

Does anyone have a more innovative may of communicating this setting change eg introductory Splash Screen.

I have a problem in relation to transposing formula values from one worksheet to another.

In Sheet1 I have rows for formulas which I want to transpose into columns in Sheet2

When I use the copy and transpose formula the formulas are transposed but no longer reference Sheet1 but reflect the references in the worksheet I copied into Sheet2.

Is it possible to use transpose with a Paste Link so when the formulas are transposed they reference the orginal worksheet. ie Sheet1

An alternative without a loop, with data beginning in row 2. Note, the criterion "Outstanding" is hard coded. If that is the only value you will ever search for, then fine. If not, we can modify this to have your criterion entered in another cell and reference that cell range in the code:

ActiveSheet.AutoFilterMode = False
Dim FilterRange As Range, DataRange As Range
Set FilterRange = Range(("A1"), Cells(Rows.Count, 2).End(xlUp))
Set DataRange = Range(("A2"), Cells(Rows.Count, 1).End(xlUp))
FilterRange.AutoFilter Field:=2, Criteria1:="Outstanding"
DataRange.SpecialCells(xlCellTypeVisible).Value = "Outstanding"
ActiveSheet.AutoFilterMode = False

Thanks for that - Its not quite what I was after, but its considerbly more than I had before.

P.S I wanted column A to retain its existing value if it didn't match column B. But I think I'll cut my losses, coz my VB sucks even more than my excel

Thanks again mate:guitar:

Hi, I am desperate for an answer to this question - I need to get excel to look up two values and if the one cell fits a certain criteria, replace the oppoiste cell with the aforementoned criteria... Confused?!

I would appreciate any help. Take a look at the attachment

You can use the entirerow = hidden property, like this

Sub Macro1()


Dim R As Range
Dim Row As Range
Dim i As Integer
Set R = ActiveSheet.Range("A1").CurrentRegion
Set R = R.Offset(1, 0).Resize(R.Rows.Count - 1, R.Columns.Count)
For i = 1 To R.Rows.Count
  If Not R.Rows(i).EntireRow.Hidden Then
     MsgBox "Row " & i + 1 & " is selected"
  End If
Next i


End Sub

Hans

Thanks!! It works like a charm! :guitar: