Simple VBA help

**kamelkid2** · 07-13-2012, 11:02 AM

Please Login or Register  to view this content.

I am returning a blank cell in this case. the cell that is referenced in Comment contains text. Im very new to VBA so i am sure it is something simple and stupid but i cant seem to source the error in this one. worksheet digest cell b6 contains a number that corresponds to a row of interest fyi, and i want to copy the value of the cell directly below it into the digest worksheet.

**FortySixAndTwo** · 07-13-2012, 11:05 AM

I don't know if the following is the answer but try

Please Login or Register  to view this content.

I've seen people not use the .Value property but I always do just to be sure.

EDIT: At 122 posts you should probably be using a better title than the one you have provided the forum.

**tigeravatar** · 07-13-2012, 11:06 AM

When using the Cells() method, the rownumber is the first argument, and the columnnumber is the second argument
So if the comment should be coming from sheets("user") column A, you need to have:

Please Login or Register  to view this content.

**kamelkid2** · 07-13-2012, 11:06 AM

still same scenario unfortunately

**dilipandey** · 07-13-2012, 11:07 AM

Hi kamelkid2

Suggest you change the thread title to reflect the query being asked.. see the forum rules:-

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey

<click on below 'star' if this helps>

**FortySixAndTwo** · 07-13-2012, 11:07 AM

I don't want to hijack this thread but my question is related (somewhat).

@tigeravatar, is the .Value needed to draw out the value of the cell or does it not really matter?

**kamelkid2** · 07-13-2012, 11:08 AM

Originally Posted by tigeravatar

When using the Cells() method, the rownumber is the first argument, and the columnnumber is the second argument
So if the comment should be coming from sheets("user") column A, you need to have:

Please Login or Register  to view this content.

thank you. at least i know my rudimentary understanding of variables is correct. now i just need to mind my p's and q's. thank you for quick help!

**kamelkid2** · 07-13-2012, 11:10 AM

Originally Posted by FortySixAndTwo

I don't want to hijack this thread but my question is related (somewhat).

@tigeravatar, is the .Value needed to draw out the value of the cell or does it not really matter?

taken from the guide i am using to learn VBA

'Value is the default property for a Range object. In other words, if you omit a
property for a Range, Excel uses its Value property'

**tigeravatar** · 07-13-2012, 11:11 AM

@FortySixAndTwo, when referencing a single cell, the default property returned is the .Value, so it isn't actually necessary to specify .Value. However, if you are referencing more than a single cell, there is no default property returned, so then it becomes necessary to specify what you want out of that range object. Also, dates can cause a problem due to regional settings, and numbers can cause problems due to cell formatting or being stored as text, so its best to get those using .Value2 instead of .Value. Generally speaking, you should always explicitly declare what you're looking for as good practice.

**Cutter** · 07-13-2012, 11:12 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.