where or how do i create a function that ive been given?
 

ive been given a function in text but i dont know where to enter it??

--
leme
-----------------------------------------------------------------------
lemel's Profile: http://www.excelforum.com/member.php...fo&userid=1594
View this thread: http://www.excelforum.com/showthread.php?threadid=27494

where or how do i create a function that ive been given?
 

With only one workbook open,

do Alt+F11 and this should take you to the Visual Basic Editor (VBE). in
the menu there, choose Insert=Module. Paste the code in that module.

Now do Alt+F11 to get back to excel.

--
Regards,
Tom Ogilvy

"lemel" wrote in message
...

ive been given a function in text but i dont know where to enter it???


--
lemel
------------------------------------------------------------------------
lemel's Profile:
http://www.excelforum.com/member.php...o&userid=15944
View this thread: http://www.excelforum.com/showthread...hreadid=274944

where or how do i create a function that ive been given?
 

Continuing this line of thought...
I am trying to get Excel to automatically page break at the end of
group of data specific to a person. The # of rows is not fixed
depending upon how much data we have for the person. The first colum
is dedicated to the name.
I am desperately trying to figure out VBA. I found this formula i
another help message in this forum:
Sub Insert_Page_Breaks()
'set to look for teachers names in column A
'will put a page break when the name changes
Set rng = Range(Cells(2, 1), _
Cells(Rows.Count, 1).End(xlUp))
For Each cell In rng
If Trim(cell.Value) < _
Trim(cell.Offset(-1, 0).Value) Then
ActiveSheet.HPageBreaks.Add cell
End If
Next
End Sub

It is supposed to do the trick. Based on what I read in the 2nd pos
of this thread, I pasted it in. It doesn't print out with th
automatic page breaks.
Do I have to activate it in some way? Or does it just work on its own
I can't find much understandable help on VBA and would sure appreciat
a simple explanation of how it works. Thanks! Kimberl

--
Kimberl
-----------------------------------------------------------------------
Kimberly's Profile: http://www.excelforum.com/member.php...nfo&userid=732
View this thread: http://www.excelforum.com/showthread.php?threadid=27494

where or how do i create a function that ive been given?
 

In order to run that code Kimberly you'd have to go to your spreadshee
and go to tools/macros/maros, then look for your macr
"Insert_Page_Breaks" and press the run button

--
DK
-----------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...fo&userid=1451
View this thread: http://www.excelforum.com/showthread.php?threadid=27494

where or how do i create a function that ive been given?
 

...........

--
Kimberl
-----------------------------------------------------------------------
Kimberly's Profile: http://www.excelforum.com/member.php...nfo&userid=732
View this thread: http://www.excelforum.com/showthread.php?threadid=27494

where or how do i create a function that ive been given?
 

anytime, just glad i can finally help out here :

--
DK
-----------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...fo&userid=1451
View this thread: http://www.excelforum.com/showthread.php?threadid=27494