Martin_H
Board Regular
- Joined
- Aug 26, 2020
- Messages
- 190
- Office Version
- 365
- Platform
- Windows
Hi,
I have been using this macro which is copying everything (formulas, formatting etc.):
I would like to edit that macro to copy as a plain text only (without formulas or formatting).
It has to work in Shared Workbook.
Help is much appreciated.
I have been using this macro which is copying everything (formulas, formatting etc.):
VBA Code:
Sub Macro_1()
For Each ws In ActiveWorkbook.Worksheets
If ws.Name = "ß_PCF_1" Then
ws.Range("B3:M100").Copy Sheets("ß_PCF").Cells(Rows.Count, "b").End(xlUp).Offset(1)
End If
Next ws
End Sub
I would like to edit that macro to copy as a plain text only (without formulas or formatting).
It has to work in Shared Workbook.
Help is much appreciated.