Timeline for Is there a concise way to do Range("A1:A10").Value = Range("A1:A10").Value + 1 in vba
Current License: CC BY-SA 4.0
9 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Oct 2, 2019 at 8:00 | answer | added | shrivallabha.redij | timeline score: 0 | |
Oct 2, 2019 at 7:43 | comment | added | aucuparia |
the type mismatch is because .Value is returning an array, and + doesn't work on arrays.
|
|
S Oct 2, 2019 at 7:32 | history | suggested | riskypenguin |
Removed tag excel-vba, added tag excel
|
|
Oct 2, 2019 at 7:11 | vote | accept | Jeremy | ||
Oct 2, 2019 at 6:38 | answer | added | Damian | timeline score: 1 | |
Oct 2, 2019 at 6:36 | review | Suggested edits | |||
S Oct 2, 2019 at 7:32 | |||||
Oct 2, 2019 at 6:17 | history | edited | Jeremy | CC BY-SA 4.0 |
added 209 characters in body
|
Oct 2, 2019 at 6:00 | comment | added | Damian | You are going to need a loop... If performance/speed is your concern, you can always drop the range into an array, loop there and paste it back to the range. | |
Oct 2, 2019 at 5:59 | history | asked | Jeremy | CC BY-SA 4.0 |