in a macro i have this:
col=cell.column 'suppose col=16384
then i need to place in a cell this formula
=(XFD2708*100/XFD2597)-100
so i'm looking for "something" that can convert
16384 in XFD
i hope i have explain myself , thanks a lot
in a macro i have this:
col=cell.column 'suppose col=16384
then i need to place in a cell this formula
=(XFD2708*100/XFD2597)-100
so i'm looking for "something" that can convert
16384 in XFD
i hope i have explain myself , thanks a lot
Best perhaps to enter the formula using R1C1 notation
That's not to say you can't convert the number to column string but there's really no need for it.Please Login or Register to view this content.
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
thank for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks