transpose=true

  1. K

    Copy & Paste Loop - Very Very New to VBA

    Hi everyone, I need some help, I am learning lots but I'm trying to make a loop. I'm trying to get the Range I'm copiyng to move down 3 cells each time and the place pasted down by one. Copy - A1:A3, A4:A6, A7:A9...etc Paste: G1,G2,G3...etc. In context, I am coping Name, age & location and...
    • KJHEXCELL
    • Thread
    • false operation=xlnone paste=xlpasteall skipblanks= transpose=true
    • Replies: 4
    • Forum: Excel Questions
  2. K

    Looping through a set Spefiic set Range and Pasting in next empty cell in another column

    Hi, I have this code below, which selects a range in each line and paste the data in another sheet in column E in the next empty cell. I do this for an offset up to 116 and this may increase. I am struggling to find a loop code that will loop through a set range and paste the data in Column...
    • KNKN9
    • Thread
    • cell column empty sheetsbrands_2018 transpose=true
    • Replies: 3
    • Forum: Excel Questions
  3. D

    Copy and Paste (transpose)

    Hi, I have sheets in t (he same workbook that I need the values of the cells to be copied and pasted from sheet2 to sheet1 depending on a name selected from a drop down list. However, the cells in sheet1 are spread over the sheet. Here is an example of what I have done so far for the first...
    • Daroh
    • Thread
    • cells sheet1 sht2 transpose=true xlpastevalues
    • Replies: 14
    • Forum: Excel Questions
  4. M

    VBA - please modify the provided code

    Czy możesz mi powiedzieć, jak powinien wyglądać poprawny kod i gdzie popełniam błąd? Mój kod to: Sub Dowodcy () ' ' Dowodcy MAKRO " Jeżeli jest to wartość ( "C2") = Wartość ( "BA2"), a następnie Range ( "J3: AN4"). Wybierz Application.CutCopyMode = False...
  5. S

    Looping across cells, rows, worksheets in VBA

    Hi everyone, I'm new here (thanks for having me) and am a novice user of Excel. I'm struggling with what I'm sure are basic looping issues in VBA, and am hoping that someone could direct me to a useful instructional website or perhaps be kind enough to help me get started in loops. Some...
    • stata_user
    • Thread
    • operation=xlnone selection.copy selection.pastespecial skipblanks=false transpose=true
    • Replies: 2
    • Forum: Excel Questions
  6. J

    Making code dynamic

    Hi, I have this code which seems not proper when there's any change in input file. The code I made is Static which I want to convert into dynamic. The problem is I don't know the way. Here's the code I've made which I want as dynamic as possible: Private Sub OutputBttn_Click() Dim fName As...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top