60 626
Assignments Done
97,8%
Successfully Done
In April 2018

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.<br>
<br>
Dim ColCounter As Integer

<br>Sub open_form_testing_one()
<br>'
<br>' open_form_testing_one Macro
<br>'
<br>
<br>'

<br>ColCounter = 1
<br>Selection.Copy
<br>Sheets("Sales Report ").Select
<br>For ColCounter = 1 To 200
<br>If Sheets("Sales Report ").Cell(ColCounter, 1) = "" Then [error line]
<br>Range("A" & ColCounter).Select
<br>ActiveSheet.Paste
<br>Application.CutCopyMode = False
<br>Range("C21").Select
<br>End If
<br>Next ColCounter
<br>End Sub
<br>
if possible please change the code and send back the correct code via email.
Expert's answer
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 first!

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions