EXCEL FEED: Re: [ExcelVBA] Would love feedback on first code

Sabtu, 14 Juni 2014

Re: [ExcelVBA] Would love feedback on first code

> the erows line was copied from an example I found,

> hence the format inconsistency

Ah, but that's not an excuse. :-) Even copied bits of code should be made to match your style.

> I tried using txtPitcher to change worksheets,

> but could not get it to work

That could be because you didn't have a .Text attribute on the txtPitcher and Excel made a wrong assumption. Reinforces my point about always using the attributes.

Regards, Dave S

----- Original Message -----

From: jefff@rogers.com [ExcelVBA]

To: ExcelVBA@yahoogroups.com

Sent: Saturday, June 14, 2014 9:46 PM

Subject: RE: [ExcelVBA] Would love feedback on first code

Thank you very much Dave and Bob for your feedback. Much appreciated.

Dave, the erows line was copied from an example I found, hence the format inconsistency. You are correct, Sheets1 in EntryRow should have been Pitcher. I caught that when testing. I tried using txtPitcher to change worksheets, but could not get it to work, so I introduced the Pitcher variable.

Thanks again for your help.

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1432 / Virus Database: 3955/7175 - Release Date: 06/14/14

__._,_.___

Posted by: "David Smart" <smartware.consulting@gmail.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (6)

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Visit Your Group