Answer to Question #1847 in Visual Basic for Luke Young

Question #1847
I have opted for the double award in college but for one of the units requires VBA programming for an excel spreadsheet - for this sheet i have written a program that will copy and past whatever is highlighted and then clicking a macro will paste the data to the sheet under the existing data without overwritting this data - i shall provide the coding i have done - the problem is that when i debug the program there is an error - the computer technicians are unable to help.



Dim ColCounter As Integer


Sub open_form_testing_one()

'

' open_form_testing_one Macro

'



'


ColCounter = 1

Selection.Copy

Sheets("Sales Report ").Select

For ColCounter = 1 To 200

If Sheets("Sales Report ").Cell(ColCounter, 1) = "" Then [error line]

Range("A" & ColCounter).Select

ActiveSheet.Paste

Application.CutCopyMode = False

Range("C21").Select

End If

Next ColCounter

End Sub


if possible please change the code and send back the correct code via email.
1
Expert's answer
2011-03-16T06:27:41-0400
Unfortunately, your question requires more work than to be done for free. You can submit it as an assignment to our control panel set the deadline and our experts will assist you.

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS