0.pastespecial

Hi just wondering is there any way of tidying up the code below as it is repeated quite a lot just wondering if there was a easier/better way in putting it all together. hope you can help. Private Sub CommandButton3_Click() With Sheets("Sheet1") .Columns("C:C").Sort...

Hi I have the code below where I am copying data over from sheet1 to New, but first I want in sheet1 column b sorting A-z, I have the code below where everything else works apart from the first part sorting column C in Sheet1 A-Z, please can you help? Private Sub CommandButton3_Click() With...

i am new to VBA, I use following code to copy past offset Down is OK. "Sub Copyoffsetdown() Range("A1:A6").Copy Range("h555").End(xlUp).Offset(0, 0).PasteSpecial Paste:=xlPasteValues End Sub" but How to change the code , so i can copy rang(A1-A6) to H1-H6, then I1-I6, J1-J6 up to Z1 to Z6...

Hi all I can't seem to find the right code for what I want to do. I've designed a very basic POS type system in excel for our shop: When a stock number is typed into column A, column B,C,D & E are populated using Index & Match formula. When I press the cash/card/cheque button, Excel copies the...

In a previous thread I was adviced to get rid of .Activate, .Select, and .Selection - as these both slow down code and is known to cause flickering screen. And then to put Application.ScreenUpdating = False at the top of my code. Through several other threads and a lot of help, I've changed...

Self taught... Needing some help pasting information from "DW" to tables... Code pastes to the tables correctly for "Range A" of target worksheet, but the table expands to the bottom of "Range A" when the information is pastes and "Range B,C,D,E, ETC" offsets below the previous range in the...

Hi What i need to do is copy and past data from one sheet to another . The issue is that i want to copy the values and formats but not the formulas. I have the folowing code Sub CopyWeekly() Sheets("WeeklyDetail").Unprotect Password:="xxxx" Range("a1:g40").Copy...

Hello, I have literally started learning basic VBA this week. So far all my codes are immensely long lists of copy and pasting and I'm more than sure it can be condensed down :confused: Literally my code is: Private Sub KEY_OUT_Click() Application.ScreenUpdating = False Dim copySheet As...

I have a DBFORMAT sheet where there are 6 types of DBs (Distribution boards) differentiated by headings in rows. There is an RADB sheet with a dropdown menu and “ADD” button. When I select the DB from dropdown menu and press ADD, the corresponding rows of item from the DBFORMAT is copied and...

Hello New here and wondered if I could have some help please? I have just upgraded to 2016 and have come across an issue with some vba that has previously been working fine. I am at a dead end as to why it is no longer working, if someone could shed some light I shall be eternally grateful :)...

Hello, I have a spreadsheet that puts a stock into a specific tab depending on its industry. The trouble I am having is that I sometimes have 2000 stocks this has to cycle through and it takes a significant amount of time. If anyone can think of a way to speed it up I would appreciate it. Code...