-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
bottomd
-
T
Change this code to paste as values only
Guys, I have found this code which works great for me but i want to paste the data into the 'All data' sheet as values. I cant for the life of me figure out where to put the paste special code. I have tried several different ways but not joy. Can anyone help? Sub CopyRange() Dim bottomD...- thedeadzeds
- Thread
- bottomd code data dim paste
- Replies: 5
- Forum: Excel Questions
-
F
match cell value to worksheet name and copy row data
I have a problem very similar to the one posted on this thread https://www.mrexcel.com/forum/excel-questions/713184-macro-match-cell-value-worksheet-name-copy-row-data.html and the code supplied by mumps look very promising Sub CopyRows() Dim bottomD As Integer bottomD = Range("A" &...- Fazila
- Thread
- bottomd copy dim end row
- Replies: 4
- Forum: Excel Questions
-
N
Macro loop to paste as value
Hi All, I am using below mentioned code for consolidating data. can any one assist me to paste all the data as value while consolidating in "consolidate data" sheet. [CODE] Sub CopyRange() Dim bottomD As Integer Application.ScreenUpdating = False Dim WS As Worksheet For...- Negi1984
- Thread
- bottomd consolidating data dim paste
- Replies: 2
- Forum: Excel Questions
