Does anyone know the VB code for the Excel =CHAR( function
ie =CHAR(65)= A
Cheers
pvr928
I'm having trouble with character codes in a formula that is supposed to show "growth" and "loss". The following is the formula; however, in the spreadsheet, instead of showing the symbols for arrows pointing up, down, right and left, I get, for example, 0.00% CHAR(25B2), which was supposed to show up in the spreadsheet as an arrow pointing upward. I am using the Ariel font, and these symbols are a part of that particular font. Please tell me what I'm doing wrong in this formula!
=IF(E11>0,CONCATENATE(FIXED(E11*100,2,TRUE),"%",REPT(" ",10-LEN(FIXED(E11*100,2,TRUE))),"CHAR(25B2)"),IF(E11
i have a set of data string that i want to compare character by character to find out how they differ. if they are different find the positions in which it changed. the changed happened at position 1 then do something if the changed happened at position 13 then do something.
ex.
10200K00S
1020KK00S 'changed happened at 5th position
1020KK000 ' changed happened at 9th position
I am looking to replace a single char with an ASCII character determined by the loop.
The follwoing are code samples are what I have tried with no success.
Code:
For a = 1 To 20
For i = 1 To a
For z = 1 To 255
'This is my problem ***************************
Mid(Proj i, 1) = Chr(Asc(z))
End If
Next z
Next i
Next a
and
Code:
For a = 1 To 20
For i = 1 To a
For z = 1 To 255
'This is my problem ***************************
Proj = Application.WorksheetFunction.Replace(Arg1:=Proj, Arg2:=i, Arg3:=1, Arg4:=(Chr(Asc(z))))
End If
Next z
Next i
Next a
Hi All
I am trying to remove all traces of Char(31) from a column of data can someone give me an idea how to do it by Macro.
Sample text is this:
"Char(31)Subnet Mask " for columns "A" & "B"
BTW, it's the actual character, not the text Char(31).
OMG, I hope it's char(31), it's a little square.
Regards
Michael M
I am trying to manipulate strings dumped into Excel from
another system. I am combining strings from column G into
a single cell in column H, which works well. However, I
don't want the strings strung together in the cell. I
would like to do the equivalent of the ALT + enter
function after each string so that they are in their
own "lines". I would think that this would be possible,
but can't figure it out. A portion of my code is below.
Thank you
Dim ct As Integer
ct = 0
test = 0
If ActiveCell.Value <> "" Then
loop1:
ct = ct + 1
cmb = ActiveCell.Value
If ActiveCell.Offset(ct, 0).Value = " " Then
Do Until test = ct
cmb = cmb & ActiveCell.Offset(test + 1, 0).Value 'need
help here
test = test + 1
Loop
ActiveCell.Offset(0, 1).Value = cmb
ActiveCell.Offset(ct + 1, 0).Select
GoTo rs
End If
GoTo loop1
End If
I'm running Excel 2003; trying to insert in a cell a "phone" symbol which I've inserted via above Char code.
However in cell it only appears when I double click cell; is there a workround for this please.?
I've inserted a downward arrow in a cell and would like to see if there is a code number that I could use in a formula?
I used =CHAR() to find 255 characters, is that all there is?
Is there a way to find the code that excel uses for its built in functions? For example, excel has the betainv (and now beta.inv in 2010) function and I would like to know how the calculations work (so I can write a similar function in another program). My own made up algorithm takes a long time so I would like to see how excel does it. Is there a way to see this information? Thanks.
Hello all,
SHORT VERSION:
I want to learn how to write user-defined (worksheet) functions in VBA code, is there a way that I can see the VBA behind the existing worksheet functions? I figure they would be a resource to learn from.
LONGER VERSION:
I was asked the other day to write a formula for a colleague that linked to a worksheet that was triggered by the name of that worksheet being in the cell to the left.
I did this by fiddling with the hyperlink() function in the cells but in doing so it seemed a good idea to simply create a user defined function in a code module with a view to using that in my column of cells to get my sheethyperlink, rather than manipulating the existing hyperlink function at cell level. The problem is I have no experience really of writing functions and would like to learn. I'm sure seeing how the existing functions are coded would be very enlightening.
Thanks for reading
Jon
