Hi gurus,
Trying to build a project and got stuck on one piece of code.
Assume you got formulas in A1:Z1. I would like macros to copy that range and paste values in A10:Z10. But... There is a catch. I want the copy range changing according to selected column. Example:
If I have selected any cell in C column - copy & paste range changes to C:Z, if G column selected - range is G:Z etc. So, the beginning range changes according to selected column and Z is always fixed.
How do I do this? Please bare with me, I am a very beginner in VBA...
Bookmarks