code to assign formula without $ sign.

**vaasto2003** · 08-21-2017, 08:22 AM

Good Afternoon,

I novice in Excel macro and developing a routine to paste multiplication formula and page sum formula.
The formula is pasted but, i want without $ sign ( like =$c$2 *$e$2). but i need without $ sign.

The below is my routine

Please Login or Register  to view this content.

Another,

Please Login or Register  to view this content.

Thanks in advance

**JOHN H. DAVIS** · 08-21-2017, 08:49 AM

Maybe:

Please Login or Register  to view this content.

**vaasto2003** · 08-21-2017, 09:06 AM

Sorry John,
It do not work. Remain with $ sign

**JOHN H. DAVIS** · 08-21-2017, 09:23 AM

Works for me when I test it?

**vaasto2003** · 08-21-2017, 09:42 AM

Apologize John,
It work fine.

Thank you very very much

**JOHN H. DAVIS** · 08-21-2017, 09:51 AM

You're welcome. Glad to help out and thanks for the feedback. If that solves your problem then from Thread Tools above your first post, select "Mark your thread as Solved".

code to assign formula without $ sign.

LinkBack

Thread Tools

Rate This Thread

Display

code to assign formula without $ sign.

Re: code to assign formula without $ sign.

Re: code to assign formula without $ sign.

Re: code to assign formula without $ sign.

Re: code to assign formula without $ sign.

Re: code to assign formula without $ sign.

Thread Information

Users Browsing this Thread

Similar Threads

Electronic Sign-off in Excel - Code or 3rd party or Add-in

VB Code to assign Macro Button to certain Code

[SOLVED] Formula or vba to assign a priceing band to UK postal code.

Add Percentage Sign to Code

[SOLVED] code to insert dash sign

Convert sign ( - ) to value hex code

Code Sign PW Protected Project?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions