Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Copying Records
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Copying Records
Resolved · High Priority · Version 2007
Reply
Copying Records
Is it possible for the content of a cell to be copied if the value of the cell is greater than zero ?we created a code that had the following to copy the data in the cell if the salesperson name matched strName
If Sheets("Total Sales").Range("a10").Cells(introwcount, 10).Value = strName Then
Can the last bit be changed to somehting like this
If Sheets("Total Sales").Range("a10").Cells(introwcount, 10).Value = > 0
to copy all the content when the value of the cell is greater than zero
The code i have given below still copies all records even when there is a "0" in the reference cell.
Thanks
Lee
For upcoming training course dates see: Pricing & availability
RE: Copying Records
Hi LeeThanks for your question
your code
If Sheets("Total Sales").Range("a10").Cells(introwcount, 10).Value = > 0Is copying it if it is greater than OR equal to 0
Try
If Sheets("Total Sales").Range("a10").Cells(introwcount, 10).Value > 0(without the = )
Instead
Regards
Stephen
|
 |
|
» Forum post: Acess |
How do you lock down the data from other users
