Copy, Paste Special Values all sheets in workbook
of course, so you need to activate a sheet you want to deal with
je napisao u poruci interesnoj
roups.com...
I'd like to write a macro that goes to each sheet in turn, selects all
cells and paste special values. I've got his far but it only seems to
work for the active sheet:
Sub removelinks()
Dim wks As Worksheet
Dim wb As Workbook
Set wb = ThisWorkbook
For Each wks In wb.Worksheets
'---------- add next line after for each
wks.activate
|