Hello,
How can i copy paste 1 range of cells into another sheet without select.
I had this:
Although this selects the destination range and i can't have that.
Please Login or Register to view this content.
I now have this:
The ranges have values but in the second one, it DOESN'T select, although doesn't copy nothing..Please Login or Register to view this content.
I have the values in the "somar cores" Sheet, and want to copy them to my activeSheet
Exemple for 10 rows and 5 columns
Please Login or Register to view this content.
Kind regards
Leo
I Need to use the variables...Originally Posted by LeoTaxi
MetrosLinearesporCores = Worksheets("Somar cores - não apagar").Range("A5:BA5")
NrColPrimeiraCor = 18
It's a number this last one.
I need to copy the metroslinearesporCOres to nrColprimeiracor
Hope you can help me out
Already Tried:
But doesn't work..Please Login or Register to view this content.
Your first code is correct but you should write it like this
The fact that the destination cell or range remains selected is 'works as designed' it is is a nuisance but, we'll have to live with itPlease Login or Register to view this content.
È uma pena mais nõ tem outra solução
Pode tentar esto:
This way you save the initial location and return to itPlease Login or Register to view this content.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
That's my last solution, cuz my activecell is not that one, it's 30 columns to left. But tomorrow there can be more or less.
That's why i need this to NOT select..
I can do that, although i need to do something like this:
I have to select the first column, in the active row. Is this correct?Please Login or Register to view this content.
Last edited by brainzlp; 10-29-2015 at 06:49 AM.
works with variable also
Kind regardsPlease Login or Register to view this content.
Leo
The copy list will be flexible, can't the 53 be like a count A:BA automatic?
The problem i am dealing is that de A5:AB5 will be flexible, what i have now, the variable needs to be changed and i write mannually what is the Start and Finish.
But wanted to have a countcolumn on that variable.
Like:
Resize(1,Count.columns(Range("A5:BA5")))
Solved with this solution:
Please Login or Register to view this content.
like this
Kind regardsPlease Login or Register to view this content.
Leo
Thanks you. Works great.
Oeps, i forgot the row number in previus
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks