Hello forum
In column A a have a set of numbers which varies from time to time. These numbers must be substracted from the previous ones.
So if Range("A1:A12") the substractions must be
A2-A1
A3-A2
A4-A3
A5-A4 and so on.
Substructions must start from the next not used cell in the same Column
Since the range varies does anyone have an idea how to put all this in a code
Thank you
A2-A1 will be used in which cell? In A2 ah?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
In next not used cell in Column A
Sorry, unable to follow
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
I hope this helps
How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
To run the Excel VBA code:
Please Login or Register to view this content.
- Press Alt-F8 to open the macro list
- Select a macro in the list
- Click the Run button
Works great
Just one more thing
How can I remove the "$" from the code in case i wanted to autofill the substraction to the right -more coloumns with numbers?
Replace this line
WithPlease Login or Register to view this content.
Please Login or Register to view this content.
Thank you so much
Sorry i cannot add reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks