-
populating the next available cell
dim dRow as double
dRow = 2
do until cells(drow,2) = ""
drow = drow+1
loop
cells(drow,2) = dcolumnBValue
cells(drow,3) = columnCValue
Deleting the section when the cursor has selected the cell it wants to delete
range("B"& activecell.row &":C"& activecell.row &"").delete xlup
Hope that helps!!
Last edited by NashProjects; 12-23-2011 at 01:57 AM.
Reason: Pressed enter too quickly
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules