2
votes
Accepted
Loop over excel cells using for loop when cells are selected using CTRL
Cells or ranges that were selected via Ctrl+Click consist of multiple Areas. To use the For Next approach, loop through each Cell within each Area:
Option Explicit
Sub ForNextLoop()
Dim oRange As ...
- 361
1
vote
MS Excel graphs do not follow decimal separator setting
After changing the separators, the chart must be refreshed, i.e. the sheet must be scrolled so that the chart is drawn again or another sheet must be activated for a moment.
- 2,320
1
vote
Excel Parent-Child Array to identify and move children not working?
First off, there are some discrepancies between your description and the code used. You said parent rows are identified where the value in column B starts with "xDay_", but the code seems to ...
- 361
Only top scored, non community-wiki answers of a minimum length are eligible