Posts by lambuhere1

Re: possible combination of names [SOLVED]

Dave, I lost all my files recently. I was looking at the same requiement again. Do you still have the link ?

Thanks

Ram P

Hi

Is there any way we can have two slides in one "normal" view so that when I go to slide show, I can see two slides !

I presume that experts in here can be of great help.

Thanks for your kind help and attention

R P

Thanks a lot for your help.

I was wondering how I missed it.

Anyway, Beer is on me.

Ram P

I don't want to search for Address...

I just want to find data, if exists do one series of steps else do another series of steps.

Thanks a lot for your kind attentin and help

Ram P

I know I am doing some minor mistake somewhere with "Find" Feature in VBA, Probably someone can shed light on it.

I want to find a string "Time" in my worksheet.

If it exists, then Do

This

Else

Do that

I am not able to put up this logic in VBA.. Any thoughts on it.

Thanks very much for your help.

Ram P

Hi

I am using the code from the link below to select a folder

http://j-walk.com/ss/excel/tips/tip29.htm

But as can be seen from the results, we get a text like " Please select a location for Backup " and on the folder userform, we get the title "Browse for folder " . Is there anyway we can change these texts ? I wanted to use my own texts in place of the given texts.

I hope the experts in here will guide me in these.

Thanks

Thanks Andy for your help.

Beer is on me !!!

Andy

Thanks for your reply.

My issue comes with respect to Amount and Minus values syntax.
If I use errorx = "C2:C10" and If I use Amount:= = errorx and the same syntax for minus values, I get a error. Why do you think is this happening?

Thanks

Ram P

Hi

I am having a issue with respect to adding error bars to each data point in a series collection. Error Propogates in Time. And my chart is Time Vs Independent variable in XY Scatter Chart Sub Type One. Error on each data point is bothe positive and negative. Both the values are same.

Chart is made from data in columns A and B. Column A has time in seconds, Column B has independent variable, lets say X. Column C has the error corresponding to each data point. Now this error needs to be represented on each data point using VBA. Can anyone be kind enough to help me out in this.

Thanks

Ram P

Its happening with Excel only. And not with any other applciations. I work at office. I am on Win 2000 SP2.

Thanks

Ram P

There are no add-ins checked with my Excel. And they are not in read only mode.

Funny thing which I observed now is that when I double click a Excel file, it annotated the file name with "1". Just observed this !!!

Do you want me to re-install Excel ?

Neale,

I have not set up any templates nor it works on only one file. It works for all my files. I dont know why this is happening.

Thanks for your help in helping me resolve my issue.

Funny way my Excel is working. Let me explain what is happening on my machine. lets say, I already have a workbook named lesson.xls I open this workbook, make the necessary changes required and when I press Save Icon or CTRL + S, Save as pop-up menu pops up and if I look at the file name in the filename dialog box, it shows lesson1.xls

As you see, we have two issues. Why is Save - As pop up menu comes out when I press Save Icon? And why is Excel Appending the already named workbook with numeral "1".

I hope you can look into this issue and help me resolve it. This is happening a quite heck of time on my Excel files.

Thanks

Ram P

Derk,

Thanks a lot for your reply. It was useful

Ram P

Hi

I am using cpearsons code to copy modules from one workbook to another workbook. But I am unsucessful to copy codes associated with workbook_open event or workbook_beforesave event. Can anyone help me out in this.

Following code from
http://www.cpearson.com/excel/vbe.htm
is being used

The following procedure will copy Module1 from Book2 to Book1.

Sub CopyOneModule()


Dim FName As String
With Workbooks("Book2")
    FName = .Path & "\code.txt"
    .VBProject.VBComponents("Module1").Export FName
End With
Workbooks("book1").VBProject.VBComponents.Import FName


End Sub

I want to copy codes associated with workbook events from Book2 to Book1. Can anyone please help me in this?

Thanks

Ram P

Have a look at

http://www.stfx.ca/people/bliengme/ExcelTips/Polynomial.htm

about usage of LINEST function

Use LINEST function of Excel to get the equation coefficients into cells.

Try this

Sub hide_row()
range_last = Range("A65536").End(xlUp).Row
For i = 3 To range_last
If (Cells(i, 4).Value = 0#) Then
Rows(i).Select
Selection.EntireRow.Hidden = True
End If


Next i

End Sub

Have a look at http://www.tushar-mehta.com/

esp the color zone in x-y chart. It should guide you on how to modify your chart.

Andy

Thanks a lot for your help. You are really Wonderful.

Beer's on me today.

Ram P