Copy & Paste specific cell in VBA if cell contains any number will not copy and paste if blank.

wolverine21

New Member
Joined
Jul 18, 2019
Messages
2
ValueCopy and paste cellsnotes
15
Since this has a number it will copy and paste[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=IF($H7<J$5,$I7,0) example of formula I'm copying and pasting[/FONT]
Cell is blanksince this is blank it will do nothing
210
Since this has a number it will copy and paste
<strike></strike>
I have approx. 200 rows in the spreadsheet.

<tbody> </tbody>

I'm trying to attach a copy of the file and or picture but I don't have a URL.
Any help would be really appreciated. I could send an example file if that would help.
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
The formula didn't copy over in the notes column.

=IF($H7< j$5,$i7,0)
 
Last edited by a moderator:
Upvote 0
If we use the < o > signs, you must put a space before and after each sign, otherwise the forum editor considers it a code and then deletes the row.

You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

​To give examples, check the following:
https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,148
Members
448,552
Latest member
WORKINGWITHNOLEADER

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top