Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Nitha120

    Adjustable worksheet range

    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...
  2. Nitha120

    Macro Problem, (Run time error 5)Invalid Procedure call or argument

    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...
  3. Nitha120

    Macro Problem, (Run time error 5)Invalid Procedure call or argument

    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...
  4. Nitha120

    Excel, Automatic saving when end program,,

    Hi im not fimilar wth the save command or workbook,save method could you show me or tell me where to find more information on it? thanks
  5. Nitha120

    Excel, Automatic saving when end program,,

    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...
  6. Nitha120

    Acess Database problem

    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...
  7. Nitha120

    Acess Database problem

    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...
  8. Nitha120

    Excel, Null

    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?
  9. Nitha120

    Macro, Maximum and minimum part of chart

    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!
  10. Nitha120

    Macro Error 5

    thanks for the help Skip
  11. Nitha120

    Macro Error 5

    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...
  12. Nitha120

    Macro Error 5

    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?
  13. Nitha120

    Macro Error 5

    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...
  14. Nitha120

    Macro Error 5

    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...
  15. Nitha120

    Macro,Multiple Workbook

    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...
  16. Nitha120

    Macro, input data button

    Thank you so much Skip! Your awesome!
  17. Nitha120

    Macro, input data button

    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...
  18. Nitha120

    Assign Button to Macro

    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?
  19. Nitha120

    Assign Button to Macro

    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!

Part and Inventory Search

Back
Top