code tweak to copy data from sheet1 to sheet2

**imatomic** · 06-28-2010, 01:58 PM

I am using the code below to copy data from sheet1 to sheet2 and it works fine as long as it's looking for for text such "ABCDEF" but when I specify "2000.00" then it returns no results. How can I make this work with the numeric value?

Please Login or Register  to view this content.

Thanks for any help.
Barry

**royUK** · 06-28-2010, 02:00 PM

By placing speech marks around it Excel is looking for a Text value not numeric

**imatomic** · 06-28-2010, 02:18 PM

I am going to have to reformat the sheet as text anyway and that seemed to work to fix the problem.

and thanks
Barry

code tweak to copy data from sheet1 to sheet2

LinkBack

Thread Tools

Rate This Thread

Display

code tweak to copy data from sheet1 to sheet2

Re: code tweak to copy data from sheet1 to sheet2

Re: code tweak to copy data from sheet1 to sheet2

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions