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!

Register Log in
  • Congratulations TouchToneTommy 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: *

  • Users: jobur
  • Order by date
  1. jobur

    Convert column ID into a letter

    Hi everyone I am sure someone must have asked this question before but I cannot find anything relating to it. In Excel I want to convert a Column ID into its respective letter. For example 2 returns "B", 82 retuns "CD" and so on Any hints? Thanks Regards JB
  2. jobur

    Copying data from 1 workbook to another

    Hi I am looking at the possiblity of copying data from 1 workbook to another without activating the 2nd workbook;.i.e the one I want to copy to My code at the moment is $------------- Sub CopyData() NbOfTimeStep = 3 NbOfNodes = 3 GroupName="Data" 'This is a variable in reality Set...
  3. jobur

    Copying from 1 workbook to another

    Hi I am looking at the possiblity of copying data from 1 workbook to another without activating the 2nd workbook;.i.e the one I want to copy to My code at the moment is $------------- Sub CopyData() NbOfTimeStep = 3 NbOfNodes = 3 GroupName="Data" 'This is a variable in reality Set...
  4. jobur

    Open files with same extension from a specific folder

    Hi I am trying to open all the files with a known extension (.prt This are normal txt file) in a specific folder. I have searched the web site but was unsuccessful in finding what I am looking for. The BV code i have got is the following ------------------- Sub OpenReportFile() Dim fs, f, fc...
  5. jobur

    Excel Formula and Range

    SkipVought Thanks for your reply. The selectionRange option I wnand to use in a formula is still giving problems. I know the maximum number of row occupied by my data MaxDataRow. I want to set up SelectionRange=Range(A1,A&MaxDataRow) ActiveCell.Formula= "max(SelectionRange) Any suggestions?
  6. jobur

    Excel Formula and Range

    Hi I would like to do the following in my Excel VB macro 1/ Select a range using the variable name: SelectionRange 2/ write a formula in a cell as such ActiveCell.Formula ="max(SelectionRange)" I want to do that because it's part of a FOR loop and the SelectionRange changes at each loop...

Part and Inventory Search

Back
Top