Search Result

Collapse
6 results in 0.0038 seconds.
Keywords
Members
Tags
excel2007
  •  
  • sandy armstrong
    started a topic Transpone Data
    in Visual Basic

    Transpone Data

    I have data in column A and i would like to copy 9 rows in that column then transpose the data in column I-R and and contunie to the next 9 rows and transpone again until it reaches the last row in column A. Then once the last part is reached delete column A AND B. I tryed to record a macro to do this but it wont loop on its own and keep going it stops after the first one the i have to press short cut key to move to the next one doing it like that...
    See more | Go to post
    • sandy armstrong
      started a topic Combine worksheets
      in Visual Basic

      Combine worksheets

      Good Morning Everyone.
      i would like to merge 6 workbook together they are all the same format all with the same headers and are all in the same folder called merged. I have this code ( below) but i keep getting User defined error on line 3and i dont understand why... Some please help me merge these files together i would appreciate it sooo much

      Thanks




      Code:
      Sub MergeAllSheets()
  Dim
      ...
      See more | Go to post
      Last edited by TheSmileyCoder; Nov 26 '11, 07:21 PM. Reason: Added [Code] before your code, and [/code] after your code. Please remember to use the tags around your code in the future.
      • sandy armstrong
        started a topic Combine worksheets
        in Visual Basic

        Combine worksheets

        Hello every , I been seaching forever for the answer to this problem, How do i combine Mutipible spreadsheet with same column headings and in the same folder. i have attached the folder below PLease help anyone,,,,...
        See more | Go to post
        • sandy armstrong
          started a topic User Forms to Search, Display and result
          in Visual Basic

          User Forms to Search, Display and result

          Hello Everyone.
          I have a question and i would appreciate if any one can help....
          Attached is a user form with 3 Search critira. I would like it to seach the worksheet display result in text box and on update that filtered list add a number(From the userForm)into in a column that says ppo #. any guidance in this will help....
          See more | Go to post
          • Rodney Roe
            started a topic How to add objects into and array
            in Visual Basic

            How to add objects into and array

            I'm using VBA in excell 2007. I have a userform with 42 butons with their names ranging from dy1 to dy42. Is there a way to put these objects into an array without listing each one? In other words I would like to use the for...next loop to add them incrementally if possible. This way I can call which ever button I need when I need it. Previously I was incrementing a string and then calling the button with a select case function, and i've just...
            See more | Go to post
            • timleonard
              started a topic How to modify code to include a duration?
              in Visual Basic

              How to modify code to include a duration?

              How can the following code to be modified to include a duration Column or "Named Range"?

              I would like to modify it so that a task that has a duration for example, three to five days would show the same task in the calendar on the corresponding days of the week .
              I believe the area to be modified is between line 250 and 282...

              Could someone point out the required changes to be made

              Thanks...
              See more | Go to post
              Previous template Next
              Working...