hi,
i have a worksheet data in excel with two column time another is height. I want to take the average for each column and make a chart based on the average value.
My question is how can I make the range adjustable according to the data range because some data will be shorter range other...
mine still dont work , I have Excel 2002
I think it has somethimg to do with the length of the file
I have this name for my files,
5-3-05 X NO 2 1.65 DO 0.05-S 21
however when i reduce the length to,
5-3-05 X N 2 1.65 D0.05-S 21
it run fine.
Is there a limit to number length or characters...
Hi guy I been stuck with this macro for days now and not able to resolve it please help.
My codes:
Sub time_vs_strain()
Dim chartData As Range
Dim worksheetName As String
Range("B8:E8").Select
Range(Selection, Selection.End(xlDown)).Select
Set chartData = Selection...
Hello guys,
I am making chart for each of my worksheet in a workbook. roughly 30 worksheets in each work book...
Is there a codes that I can insert in my macro that would:
1. save the change automatically when it finish graphing each worksheet so when the program terminate with...
oh sorry,
my table structure consist of 3 fields, date/time, tagname and value.
I want to be able to organize in way that i can select the tagname at specific date/time and it will display all the vaule. Im not familiar with the codes or how to approach this since Access is new to me.
when i...
Hi,
I am new to Access I have acouple of question,
I setup a link from my table to a live database.
I then setup Query however it taking the data for only 1 week span ..is there away to see or setup a button to select a certain dates range or exact date? if so how do i do that? im very new to...
Hi is there away to delete the result of "0" as blank?
I am doing a calculation for multiple worksheet i some range are between 1-25 other 1-30, I want a code to look at my range if it equal to Zero (0) just ignore the cell dont display the Zero.
any suggestion guys?
Hi,
How do I find the maximum and minimun x-value from the chart? I made this graph with excel and i want to write a macro that would extract the maximum value and minimum vlaue and put into a table.
Any suggestion would be great!
i used the name like
3-30-05 X DOUGH FRESH 0.0005 S-1-2
i later found out by reduce the naming i was able to graph just fine.
on other notes Skip, how do i change color of series when i graph all in one?
I have 5 graph with and i graph it all together but each line is same color i was...
I think i know the problem, when i change the worksheet name to something else, shorter and less character it work.
Does anybody know a code i can use to declare the worksheetName as something else so that no matter how many character i choose for my worksheetname it will still work?
Hi,
here are my codes
Sub Time_vs_Strain()
'declaration of vairable types
Dim chartData As Range
Dim worksheetName As String
' do not change this part deal with selecting the column
Range("B8").Select 'Initial location
Range(Selection, Selection.End(xlToRight)).Select...
Hi guys,
I been stuck in this problem for 4 days now and seem to never get it going...i have this error state:
Run time error 5
Invalid procedure call or argument
when i look at my macro file it highlight"
ActiveChart.Location Where:=xlLocationAsObject, Name:=worksheetName
for some reason my...
Hi guys,
I am trying to import multiple workbook to one workbook and save it. How do I do that?
I wrote the codes it work until it get to this line.
newSheet.Name = Left$(tempname, Len(tempname))
the error said that either my files is more then 31 character long or I am using the /,\,[], in...
Hi,
how do i make a buttons ask for the user to input the data and the values is insert to the macro to run the calculation.
Here is my codes:
ActiveCell.FormulaR1C1 = "12"
Selection.AutoFill Destination:=Range("C3:C11"), Type:=xlFillDefault
here i want the user to enter 12 so it will fill...
Oh and 1 more thing, How do I update my Summarize sheet automatically once the original has been change.
another word, Say sheet1 are 50 then I copy to my summarize sheet. When the number 50 change to 100 in
sheet1 I want the number in my summarize sheet update to 100 as well.
any suggestion?
Hi,
How do I assign 2 or more sub routine (Macro) to the button.
I want to have a button for call Summarize to run 2 subroutine rather then have separate Button for each Macro.
Any suggestion is greatly appreciated!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.