xlpasteall

  1. D

    Using IPhreeqc in Excel

    I can't get excel to do what I want after creating this VBA script: Sub sbCopyRangeToAnotherSheet() LastColumn = ActiveSheet.UsedRange.Columns(ActiveSheet.UsedRange.Columns.Count).Columns For n = 63 To 63 For i = n To n Worksheets("Data").Activate...
  2. V

    VBA Code / Formula - Modify

    Hi, Thanks in Advance, Its possible in VBA or code or formula to automate from column IX to column SO (ROW1798), its copy the formula and paste in only 5 or 10 column and after that copy that cells and paste special as value and make this till SO (ROW1798) 1. It will copy the formula...
  3. B

    Copy data from protected worksheet with VBA

    Hi all, I have this code that copies data from A1 down to J1 and down where the cells in column C (3) is not empty. Sub FilterData() ActiveSheet.AutoFilterMode = False Range("J1:Q" & Range("J" & Rows.Count).End(xlUp).Row).ClearContents Range("A1").AutoFilter Field:=2, Criteria1:="<>"...
  4. S

    VBA code to copy objects

    Hello, If possible, I would like to improve my code to be able to copy and paste all data in the sheet, including objects and attachments. Right now it looks like this: With WBPrepaid.Sheets("Usage Summary") .Activate .Range("A1:Az150").Copy WBExport.Sheets("Usage...
  5. L

    xlPasteAll in pastespecial function

    Hi I want to copy a cell then paste it somewhere. After review this website https://stackoverflow.com/questions/18968856/vba-paste-range I came with the code below. My question, what does xlPasteAll means? and also can I just after copying a cell paste it into a cell that i will select with a...
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.

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