paste values only

I fund that "paste values" is something I use a lot. I know I can use the ribbon or right click and select but is there a keyboard shortcut I can use or customise instead?

I am trying to copy an entire sheet, pasting only the values and renaming the new sheet to the current date. This code allows me to input the date manually, but it copies formatting and the formulas too. Sub AddNameNewSheet1() Dim Newname As String Newname = InputBox("Name for new...

I have some work sheets, which I maintain, that a couple of my colleagues also use and they copy some of their data into my worksheets. My work sheets are formatted and have some formulas in them and when they copy data into them, they use the paste function, not the paste values functions...

Hi, I have some code where its picking data from one sheet and dropping it into another. However i just have a small issue with one piece as its pasting the actual formula rather than just the values. can someone advise with what I am missing or what I need here to do it? Sub Copyover...

I am creating a spreadsheet in Excel 2003 for my users and have following two requirements. 1) Allow users to have Paste Values only and disable all other Paste options; 2) Force users to enable macros in a workbook I found following two VBA codes on internet that are working...

Looking to use a macro to index down a list copying the value and toggle to a worksheet and paste value into the filter to look at different project details .. Any ideas on how to use a macro to filter for one specific project would be appreciated.. Thanks,:eeek:

Hi All, I have scanned this forum a few times over the past few weeks and have found lots of handy tips to help me with a spreadsheet I've been working on for a Football Predictions League that we do at work. I am hoping that someone may be able to give me a bit of help with an issue I have...

Hi Everyone, I have a macro that Pastes everything as values, Deletes Buttons and deletes Hidden Data. Sub Prepare_Workbook() Dim lp As Double Dim wsht As Worksheet Dim Buttons As Object Dim Calc As String Calc = Application.Calculation Application.Calculation = xlCalculationManual...

Hi All, For some reason I'm unable to paste special --> Values in my macro so I can keep the formatting where I'm pasting it. I used the macro recorder to get the code but when for some reason it doesn't work. However if I use a normal paste, it works fine. :confused: Here is the code: Sub...

Dear Sir, I just like to ask, is there any way to paste speical (only value) with the help formula. we dont want to use mouse right click then select special paste. .we want to past only value by fomula, is it possible? pls help. Thanks