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 biv343 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. ckaren000

    cell.find command in excel (VBA)

    hi people, i am writing a macro in which i want to search for particular number starting with '3' in a column (say for instance C). I know, using 'cell.find' we can search it. but i don't know how to use it and more over i want to stop searching once it reaches a blank cell. thanks in advance...
  2. ckaren000

    Chart creation macro -VBA excel

    Hi everybody, i have a question regarding chart creation in excel. i have the following code to create a chart and resize the plot area. what my problem is, while creating the chart we can see how it is being resized. i don't want users to see what it is doin. as soon as it is done with the...
  3. ckaren000

    Open a file and manipluate cells

    thanks Mike. but i tried it, still its not working. it gives this error 'object dosent' support this property or method' it gave error at Workbooks("temp.xls").Sheet1.[E10].FormulaR1C1 = "=RC[-3]-5". i rightclicked on it and clicked the definition then it gave a message...
  4. ckaren000

    Open a file and manipluate cells

    Hi people, i am writing a simple macro in excel but i don't know what i am doin wrong. here is the thing i wanted to do, open a file (temp.xls) and manipluate some cell data. i created a button in a file and inputed following code Private Sub CBopen_Click() Workbooks.Open...

Part and Inventory Search

Back
Top