paste special value

Hi there, I have a workbook with integers stored in 6 contiguous columns and 3 rows. ("source WB") For example: A1:F3. However, this range changes from week to week, so the selection of the source range needs to be dynamic. I have another workbook ("destination WB") where I want to paste...

i want to paste special for following macro on destination range.Paste special not working. how to execute paste special in following condition. please reply if any one have such solution. Private Sub CommandButton1_Click() Dim wkbCrntWorkBook As Workbook Dim wkbSourceBook As Workbook...

Hello, I am using the following code to copy formulas down multiple rows (including array formulas that need to be "dragged down") based on a number in column A (ins). Every time there is a number in column 8 (ex: 5) the model will insert 5 rows and drag the formulas in that row (column A:U)...

Hello, I would like to copy a specific column from sheet1 to the next open column in sheet2. So I would like to say take cell A1 and find that in row 1 of sheet1 and copy that specific column to sheet2. In addition it is copying a value with a formula behind it when I paste it I would like it...

I've been working for countless hours on this. I am trying to convert the following code to paste special values instead of just past values. The source data is powerpivot (DAX) formulas, so i get error messages in the pasted data once the macro runs. My code is: SubSub TestagainSAFE() Dim i...

Hello, I've "inherited" and excel spreadsheet (database) and need to create a few macro's / vba functions. I am completely green when it comes to creating / writing code... Although I can read and understand what it needs to do. I have a few dynamic tables that pull totals from a pivot and...

Can formula's in the cells be removed by Excel program/functions? In Worksheet5, C2:C48 contains numeric values generated thr' formula =D2:D48. Ex: C2=D2 At a particular time, to remove formulas from C2:C48; I select, copy, paste special, values, Ok, Enter. But can it be done by say putting a...

I'm using a macro to copy the entire column A in Sheet 2 and pasting it in COlumn A on Sheet 3. The two issues I'm having are: 1. Copy: I only want to copy down the column until there is a blank cell (each row will have a value in column A until the end of the data is reached). Right now my...

i'm having trouble with this macroSub cond_copy() 'assuming the data is in sheet1 Sheets("EDITED").Select RowCount = Cells(Cells.Rows.Count, "a").End(xlUp).Row For i = 1 To RowCount 'assuming the true statment is in column a Range("d" & i).Select...

Hi, Warm Greeting To all. I am New to This forum. I have a problem Regarding Excel VBA Form in Portable-2007, Please Guide Me. I have created a Form in excel VBA that open one excel, get range of value then paste spacial value in master excal, Close previous excel without save and repeat same...