View Single Post
 
Old 06-22-2022, 03:53 AM
Marcia's Avatar
Marcia Marcia is offline Windows 10 Office 2019
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Move active cell down

Hi all. One of the office daily task is to enter disbursement transactions in a spreadsheet. To facilitate the encoding of procurement transactions that involve the computation of witholding taxes, I made an attempt to create a macro by using the "Record macro" tool. In the first 4 rows, the macro is working fine but when it is run several rows down, the cursor goes back to E6.
I found a sample vba with something like offset but when I pasted it in another line, there was an error message so I deleted it.
Would somebody please edit the "Range("E5").Select" "Range("E6").Select" lines please.
Thank you.
Attached Files
File Type: xlsm WtaxEntries.xlsm (16.9 KB, 5 views)
Reply With Quote