Novice VBA user here.
I recorded a macro to copy a specific cell from a worksheet to a cell on another worksheet in another workbook, as values only. I edited it so that it works for any source worksheet. It does seem to work OK but I'd appreciate suggested improvements please. I also want to extend it to copy B28 and B29 to AP2 and APQ respectively and I'm sure there's a neater way of doing it than repeating my code for the other two copy operations.
CopyFormulaAsText-1.jpgPlease Login or Register to view this content.
Terry, East Grinstead, UK
Bookmarks