paste special issues

In previous versions of Excel I was able to select an Excel graph, copy and using Paste Special, paste an active link in another worksheet (or in Word). I now find that in Excel 2016 Pro Plus that Paste Link is greyed out. A quick search found several other users with this issue, but did not...

I'm new to VBA and am looking for some additional assistance. I saw a previous post similar to my question but it's not working. Here's where I'm at: - A7:N12 is a named range "trailer_req_lanes" A7:n8 are titles - A13:N17 is a named range "trail_prod_queue" A13:N14 are titles - A18:N21 is a...

Hello, I have a column with values acquired from a Vlookup formula. I want to copy these into another column and hit Paste Special - Values to remove the Vlookup and keep the value. However when I do this it is only copying the first row and leaving the rest blank. Is there a step I am missing...

Hey all, On one of the projects I have an excel file and a macro to automaticaly generate 20 PowerPoints with tables imbeded so that they can be updated when the excel numbers change. To do this I call the following Sub: Sub pp_Paste(wb As String, ws As String, Ran As String, nSlide As...

I'm a bit brain dead tonight and cant make this work. Simply trying to copy the formatting of the range from N4:N5 to the entire columns of O and T, both starting in row 4. Row length will be variable from sheet to sheet. Here is what I have. Sub reformatStripes()' ' reformatStripes Macro '...

Hi, I have 8 individual data spreadsheets which update themselves through an internet connection. Using the 'paste special' 'paste link' function I have taken key columns from these 8 spreadsheets and pasted them into a new spreadsheet so that these columns will update automatically as the...

Hi there, I'm on a Mac, using Excel 2011. After using the subtotal feature I'm copying two columns of results into another worksheet using the F5>special . . . set of steps. Works great. Then I have yet another worksheet that has vlookups with matching values as those in a column in my results...