adding columns

  1. 9

    Adding into a Series of Numbers

    10 - Example Number Let's say I have a spreadsheet and I wanted to add cell example "H1" to the entire column of H. How do I write this in VBA? The number 10 could change but the 10 would already be added and it could stay that way. I am confused on how to write this one. Can anyone give...
  2. L

    Dynamic Print Range

    Please help if anyone has any ideas; I have set up an offset to make my print range dynamic (Offset($F$1,o,o,$J$1,4) so as the table expands the print range expands. CountA(I:I)+4 is in J1 to get row count. This works great, however, each month I copy the table and insert the copy in front of...
  3. J

    Adding a column to a selection in Excel (2000) vba

    Hi, Not much experience in vba. My script ends by copying a filtered range and then pasting the (special paste values) further down the page. When the script ends the pasted range is still selected. I want to continue my script by adding a column of analysis to the right of this pasted...
  4. K

    Combine Specific Columns in Pivot Table

    Hi Everyone: I have been trying to search this issue for a while with no luck: I have a list of people with certain classifications and need to "roll-up" some of those classifications into high level groups. For instance, if I have a list of people with their favorite ice cream and the $...
  5. K

    Tables in Excel

    Hi there, I have created a table in excel but want a macro to be able to add another row to the table, and also one to add another column. Could anyone assist me with this, or point me to a resource that can? Im quite a newby with using VBA and havent got much experience using tables. Regards K
  6. G

    Summing a variable length column

    Hello, This is probably easy, but I'm stuck. Below is a simplified version of the data. When I encounter a blank line in column A I want to skip a line and then sum the costs in column B. Columns A and B will have different sets of data every time and the lengths will change so the range is...
  7. N

    Inserting columns in sheet1 & sheet2 into different places in sheet3

    I know what I am trying to do should not be so complicated but I am having trouble finding out how to do it online. This is what I think I need to do: 1) to take columns A, B, and C from sheet 1 and insert them into columns A, D, and G in sheet 3. 2) take columns A, B, and C in sheet 2 and...
  8. S

    Pls help.. urgent

    Dear Folks, I have one work book Named " Data sheet" it contains Sheet 1 named "Area" IV columns (say all the columns are filled with Data), Sheet 2 named "Rainfall" it also contains data till IV (i.e. i cannot add more columns as it ask to delete last unfilled data), sheet 3 named "Villages"...
  9. R

    type mismatch: runtime error 13 vba

    Hi, i am new to VBA I am simply trying to add the rows in 2 colums into a rd column. i wrote columns(3).value= columns(1).value+ columns(2).value but it gives runtime error 13. Any help on this.....please reply soon....gotta make this work till tomorrow!! thanx in advance.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

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
Top