emptycolumn

  1. M

    Paste Values

    Hi Quick question I'm trying to copy a data from one worksheet to another. I can now copy the data the only problem is it has a formula. What im trying to paste is the values only and no longer will copy the formula. Here is my code Sub Button1_Click() Dim source As Worksheet Dim...
  2. A

    Speed Up Current Working Script - Transferring Data From One Sheet To Another

    G'day, I'm hoping someone can help me improve the speed of my script, it is currently working and does the job; however if you start getting above 1000 rows of data, it really takes some time to complete the operation. I can't improve the computers, but I figure someone might have a better and...
  3. G

    Clear Last row with first blank Cell, keeping the formulas

    Hello, i have a table where i´m going to put some sales. A is date; B is Produt and C is value. I´ve created a button for some specified products when when i click then the value apears in the row. I want to create another button the delete the last inserted row. Help appreciated. This is...
    • gotido
    • Thread
    • button cellsemptycolumn emptycolumn row sheet2.activate
    • Replies: 3
    • Forum: Excel Questions
  4. S

    VBA - Paste to Next Empty Column from Column Q onwards

    I have a Master File and Source File. Master File: Multiple worksheets, Column A to Q Source File: Multiple Worksheets, Column A to Q I am a VBA newbie. But after referring forums and etc, I managed to 1) prompt window to select Source File 2) with the help of users in MrExcel, I managed to...

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