tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,913
- Office Version
- 365
- 2019
- Platform
- Windows
It has often been said that if one were to learn a new programming language, Python would be the choice of many.
I have dabbled with it and know some basics but do not feel comfortable.
If I can solve the equivalent problem in Excel, then it'll make more sense.
Suppose I have a column of numbers in column A of Excel and simply want to add 10 to every cell. I know how to do that in VBA but how would one go about in Python?
The thing holding me back is that in Excel VBA, you have the luxury of properties such as Range, Column, Cells, etc, I can write a For Each Loop of the range or alternatively I can read the entire column into an array, manipulate, then use Resize to paste it back onto the worksheet.
I know you have tuples, lists, etc. in Python.
Thanks
I have dabbled with it and know some basics but do not feel comfortable.
If I can solve the equivalent problem in Excel, then it'll make more sense.
Suppose I have a column of numbers in column A of Excel and simply want to add 10 to every cell. I know how to do that in VBA but how would one go about in Python?
The thing holding me back is that in Excel VBA, you have the luxury of properties such as Range, Column, Cells, etc, I can write a For Each Loop of the range or alternatively I can read the entire column into an array, manipulate, then use Resize to paste it back onto the worksheet.
I know you have tuples, lists, etc. in Python.
Thanks