How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Bhavik Joshi Your Own Question

Bhavik Joshi
Bhavik Joshi, Computer Software Engineer
Category: Computer
Satisfied Customers: 276
Experience:  Product Developer at Computer Science Corporation
94617175
Type Your Computer Question Here...
Bhavik Joshi is online now
A new question is answered every 9 seconds

I have a question on Excel Visual Basic.

Customer Question

I have a question on Excel Visual Basic.
Submitted: 5 months ago.
Category: Computer
Expert:  The-PC-Guy replied 5 months ago.

have a specific question?

Customer: replied 5 months ago.
The question is how do I eliminate a red line that goes through one cell of my spread sheet?
I use a VB macro for my golf league and the last thing is does is place todays date in cell A3.
The command is Range("A3") .Value = "Last Update " & Date
When the macro runs it puts a red line through the data.
How do I get rid of the red line??
Expert:  The-PC-Guy replied 5 months ago.

can you send a file. OR can I remotely connect?

Customer: replied 5 months ago.
I can send the spread sheet
Customer: replied 5 months ago.
You can connect if that would be easier
Expert:  The-PC-Guy replied 5 months ago.

which do you prefer?

Customer: replied 5 months ago.
I have 'team viewer' if you want to connect
Expert:  The-PC-Guy replied 5 months ago.

okk, I have to send an additional service offer to make that happen

Customer: replied 5 months ago.
Sorry. Not worth $50.00
Expert:  The-PC-Guy replied 5 months ago.

ok, then please send the file.

Customer: replied 5 months ago.
OK. Where do I send it?
Expert:  The-PC-Guy replied 5 months ago.

click the paperclip icon on your chat screen

Customer: replied 5 months ago.
Can't find it!
Customer: replied 5 months ago.
I found it sorry>
Expert:  The-PC-Guy replied 5 months ago.

attach button

Customer: replied 5 months ago.
The send file function won't accept the file type. I have to zip it or something
Customer: replied 5 months ago.
That button is not on my screen.
Customer: replied 5 months ago.
There is an + Add files button on the bottom that I tried and it won't accept the file type
Expert:  The-PC-Guy replied 5 months ago.

do you have drop box or something?

Customer: replied 5 months ago.
No drop box.
Shall we just end this conversation?
Expert:  The-PC-Guy replied 5 months ago.

well if you don't want to do the remote, then I guess we have no other options./

Customer: replied 5 months ago.
Yup. Sorry
Expert:  Bhavik Joshi replied 5 months ago.

Hi Although I have not seen your excel file but it seems like in your macro for this cell "strike-through" is set & that might have caused this. You can try to zip you file and attach it here to this window. It should allow you to attach it.

Customer: replied 5 months ago.
Thanks Bhavik.. I was unable to send the excel file using the "+ Add files" button on the Just Answers screen, don't know why. In the meantime I was able to fix the problem.
Thanks agaikn
Expert:  Bhavik Joshi replied 5 months ago.

That's wonderful.

Please provide your valuable rating to me.