pastesheet

Hi all This is the code I am using (which is working well) but I cannot seem to get it to not copy the formatting from the input sheet. Can someone please assist. Private Sub CommandButton1_Click() Application.ScreenUpdating = False Dim copySheet As Worksheet Dim pasteSheet As...

HI I have where i want Range AP2 to last column to convert to number please can you help? Private Sub CommandButton1_Click() Dim copySheet As Worksheet Dim pasteSheet As Worksheet Set copySheet = Worksheets("Jun") Set pasteSheet = Worksheets("Jun") Lastrow =...

Hi good morning, i have the ode below where I am trying to copy all the data in a sheet called 'New' and paste into the last row in a sheet called 'Combined but its not working for me can you help please. Private Sub CommandButton3_Click() Application.ScreenUpdating = False Dim copySheet As...

I found this code to copy/paste a range from sheet 1 to sheet 2 onto the next empty row. It was working great until I switched to office 365. Now it won't paste onto the next empty row. Can anyone tell me what's wrong with it? Thanks! Sub SUBMIT2() Dim copySheet As Worksheet Dim...

Hi, This is a snippet of my excel macro. I can't seem to figure out how to paste both the values AND the cell formatting. I get the values I need but have had weird formatting output with all of my attempts. Any help would be much appreciated. Thanks all of you Mr. Excel heroes!! Dim...

Greetings everyone/anyone. I have a number of cells that contain data or formulas in columns A to F I want to find the last non-empty cell in column F, and then paste a copied range into column A of the same row. The following code is what I have at present, which works fine except that the...

Hello, I'm trying to copy a range of cells into a table. I want the code to skip blanks, and only enter the cells with information in them. However it keeps pasting all six rows, generally only the top line has information on it. This code works perfectly for what I'm doing, with the exception...

I'm a bit suck on this one, In need some help please to work this one out. I need to copy ALL DATA on sheet2 Range A-M and paste it in next blank row on sheet1 column B so all the copied data will sit in columns B to N And I need Todays date going into column A for each row that has been...

I am new to VBA and am struggling to find the code for this simple action through the existing forum posts. If it is possible to assist me it would be much appreciated. I have a named range on Sheet1 ("Sourcedata") referring to cells B10 to N10. I would like to copy the data in the range and...