All Questions
3
questions
0
votes
1
answer
2k
views
Formula or VBA for cell formatting using value based on a cell but formatting from an other cell
I have a fixed set of values, (0%,20%,40%,60%,80% and 100%) in column E.
If I fill a cell in column E with any of the above values, the cell G should pick formatting from another cell.
For example,
...
- 1
1
vote
1
answer
852
views
Excel 2010 VBA only affecting last row in range
I have some VBA code written in Excel 2010 to force padding around the rows in a table, but part of the code only affects the last row in the range. Here's the full code:
Private Sub ...
- 25
-1
votes
1
answer
4k
views
Updating another Excel spreadsheet from current spreadsheet
I used the VBA code in "How do you write an Excel formula that will paste a specific value in a different cell?" posted here in May 2013 and it works well to populate/fill another cell in the same ...
