tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
I think i'm having a friday,
All i'm trying to do is copy a range of cell and get the formulas not the values
but for some reason i get REf#
so for example O154 might be a simple formula like =M11 but i get error?
not sure this has happened before?
please help if you can i must be doing something so obviouse
thanks
Tony
I think i'm having a friday,
All i'm trying to do is copy a range of cell and get the formulas not the values
but for some reason i get REf#
VBA Code:
Group.Range("O154:O161").SpecialCells(xlCellTypeVisible).Copy 'Rate
Sheets("32 Invasive Species").Range("AJ143").PasteSpecial xlPasteformulas
so for example O154 might be a simple formula like =M11 but i get error?
not sure this has happened before?
please help if you can i must be doing something so obviouse
thanks
Tony