paste as value

This code exposes what I consider to be a bug in Excel along with a workaround. It will probably not occur in most circumstances. Option Explicit Sub DemoProblemWhenUpdatingFormulasInNonAdjacentCells() 'This code demonstrates a problem that I found the hard way ' as well as a...

I have a document with over 21,000 lines. The spreatsheet is totaling orders over the past year: each orange order amount and total charge is a hidden line and only the totals are visable, there could be 876 orders for oranges so when I copy and paste, all 876 lines plus the total (line I want)...

I'm really new to VBA. I'm trying to cycle through a worksheet and if the cell has a "0" then I want it to paste "UNK". Any help would be appreciated. Thanks, Public Sub change() Dim totalRow As Long 'totalRow = Sheet1.Range(Rows.count).End(xlUp).Row totalRow = 10000 Dim startRow As Integer...

I've searched for some VBA solutions to this but I haven't found one that suits my needs. I'm using Excel 2007 and I'm a VBA novice. Problem: The macro will be assigned to a command button and will be used by laypersons when they finish filling in data on a worksheet in Workbook 1. The...

Hi all, I am very new to macro and VBA writing and see that there are a lot of very talented folks on this board who may be able to help. I have 2 workbooks I work with daily. One workbook (call it GlobalData) contains global data where any of 50+ fields could have changed each day. The second...

I have a workbook with a large number of worksheets. The data in most worksheets has the same structure. For these worksheets I would like to have a macro that appends the data to a single sheet. Since the data on the worksheet have reference included I would like the data to be paste values or...

I am copying the value in a cell to another sheet's cell. I want to convert the formulas on the second cheet to reflect their value. I do this all the time within cells by using Past Special and Values however it doesn't give me that option within the Text Box Thanks

hi, i am having a vba code which needs to collect data from a webpage and paste the vallues in my excell sheet, somehow when i make the code it should just past it, then it will work but when i use the option xlpastespecial xlpastevallues then i get an error "method pastespecial of...

Need a macro to Copy cells from sheet1 (row 2) and "insert copied cells"(which would create a new row) as a value in sheet2 (row 2). Any help??