CHANGE CELL BASED ON TWO OTHER CELLS' VALUES AS COORDENATES
Closed
dbsimoes92
Posts
2
Registration date
Tuesday 1 April 2014
Status
Member
Last seen
3 April 2014
-
2 Apr 2014 à 12:55
dbsimoes92 Posts 2 Registration date Tuesday 1 April 2014 Status Member Last seen 3 April 2014 - 3 Apr 2014 à 16:20
dbsimoes92 Posts 2 Registration date Tuesday 1 April 2014 Status Member Last seen 3 April 2014 - 3 Apr 2014 à 16:20
Related:
- CHANGE CELL BASED ON TWO OTHER CELLS' VALUES AS COORDENATES
- How to change close friends on instagram - Instagram Forum
- Conditional formatting based on another cell text - Excel Forum
- How to delete cells in word - Guide
- Change lg tv name - Guide
- Excel vba change cell color based on value ✓ - Programming 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 1 April 2014
Status
Member
Last seen
3 April 2014
3 Apr 2014 à 16:20
3 Apr 2014 à 16:20
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!