CHANGE CELL BASED ON TWO OTHER CELLS' VALUES AS COORDENATES
Closed
dbsimoes92
Posts
2
Registration date
Tuesday April 1, 2014
Status
Member
Last seen
April 3, 2014
-
Apr 2, 2014 at 12:55 PM
dbsimoes92 Posts 2 Registration date Tuesday April 1, 2014 Status Member Last seen April 3, 2014 - Apr 3, 2014 at 04:20 PM
dbsimoes92 Posts 2 Registration date Tuesday April 1, 2014 Status Member Last seen April 3, 2014 - Apr 3, 2014 at 04:20 PM
Related:
- CHANGE CELL BASED ON TWO OTHER CELLS' VALUES AS COORDENATES
- Change computer name cmd - Guide
- Change lg tv name - Guide
- Excel macro to create new sheet based on value in cells - Guide
- How to change number of best friends on snapchat - Guide
- Count if cell contains number - Excel Forum
2 responses
Ok, try this.
Instead of making the cell selection directly, formulate it into a RANGE. Try that.
If the column is always "C", then formulate it by:
somevariable="C"& a &":C"& b;
Range(somevariable).select;
"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon
Instead of making the cell selection directly, formulate it into a RANGE. Try that.
If the column is always "C", then formulate it by:
somevariable="C"& a &":C"& b;
Range(somevariable).select;
"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon
dbsimoes92
Posts
2
Registration date
Tuesday April 1, 2014
Status
Member
Last seen
April 3, 2014
Apr 3, 2014 at 04:20 PM
Apr 3, 2014 at 04:20 PM
thanks ac3mark, but the "C" is the value i wanna put inside the cells at sheet "13" located in coordenates (a,b), where a and b are located at sheet "verso", where the sub is also located! but thanks for the somevariable formula, it was very useful in another worksheet of mine!