1

3_hold_af_2_opstilles_aut.xls


Formation of teams

2

6_hold_af_5_mand.XLS


Make 6 teams of 5 men on

3

adder_iht_baggrundsfarve_i_celler.xls

No

Summation according to background color of the cell - the associated VBA code will in this example, create a user-defined function that puts numbers together that have the same background color as the cell in which the function is entered

4

advarsel_vaerdi_allerede_tilstede_i_ark.xls

No

Control on new number is already in columns A - The associated VBA code will in this example continually monitor whether an entered number already exist in columns A of Sheet1. If it already exists, the user can choose to delete the new or still add it.

5

aendre_cursorform_til_vent.xls

No

Changing cursor appearance, where sheet-area - The associated VBA code will in this example, make the cursor on from the normal arrow to a kitchen timer (wait) in the colored area in sheets1 if a cell in this field is activated

6

aendre_datoformat.xls

Yes

The first example makes it possible to change the date format from YYYY-MM-DD to DD-MM-YYYY. The second example does the same, but there is a built-in option for the user to change further in the final format.

7

aendre_datoformat_variabelt.xls

No

The first example makes it possible to change the date format from YYYY-MM-DD to DD-MM-YYYY. The second example does the same, but there is a built-in option for the user to change further in the final format.

8

aendre_kaeder_i_fil.xls

No

Changing links between files - The associated VBA code will in this example, make it possible to change a link to another file.

9

aflaes_skaermoploesning.xls

No

Reading of the current screen resolution - The associated VBA code will in this example see the actual screen resolution

10

afstemning_hhv_spec_af_periodiseringskonto.xls


Specification and reconciliation of periodiseringskonto

11

aktiver_anden_aaben_fil.xls


Hide current file and activate another open file

12

alan.xls

Yes

Demo

13

alfabetisk_sortering_af_regneark.xls

No

An example that makes life easier if you are interested in getting sorted all its spreadsheet in his file in alphabetical order

14

alle_dubletter_i_ark1_kopieres_til_ark2.xls

No

Give the duplicates in the current sheet in another sheet - The associated VBA code will in this example indicate the duplicates explodes in sheets1 in sheets2

15

alle_formler_og_links_til_vaerdier.xls

No

Converts all the formulas and links to values

16

alm_tal_til_checktal.xls

No

There is via VBA code created a function "= checktal (xxx)" This feature results in the function of the remaining value converted to the number of letters, as used for example. on checks.

17

altid_bestemt_dir_ved_save_as.xls

No

Always save in the code listed in the library - the associated VBA code in this example will do that always gemmesi it into the code specified directory. Here C: \ alan

18

AM_eller_PM_dovenskab.xls

No

This saves the user to type ":" - the sign of times are a la 09:00 AM.

19

animeret_graf_demo.xls

No

Graph line moves according to the specified graph data.

20

antal_af_feks_et_navn_med_given_skriftfarve.xls


Count the number of instances of alan written in red

21

antal_gange_samme_data_i_omraade.xls

No

Count duplicate words spelled the same way - the associated VBA code will in this example, create a user-defined function that can count the number of times in an area where the same word appears spelled / written one

22

antal_onsdage_i_en_given_maaned.xls

No

Count how many of a given weekday there are in a given month - the associated VBA code will in this example, create a user-defined function that counts how many units of a given weekday there is one particular month

23

arbejdstidsberegning.xls


Calculation of working

24

ark_med_arbejdsuge_man_til_fre.xls

No

Indicate working in sheets - without week-end'r - The associated VBA code will in this example indicate Mondays to Fri-days in the sheet (work week), thus not Saturdays and Sundays

25

ark_pr_mdr.xls

No

Insert one sheet per month - delete other sheets - The associated VBA code will in this example, insert one sheet per mdrjan-dec and delete other sheets (incl. Sheet here and "AJ") then save the file to dinharddisk before running the macro.

26

arkmenu_on_off.xls


Turn the menu bar (lyrics) off and on

27

arknavne_iht_liste.xls

No

Here, it is possible to have the sheets in the file named according to a list indicated in Column A of a sheet

28

arknavne_med_loebende_numre.xls

No

Names new sheet with consecutive No.

29

aut_maaneds_kalender.xls

Yes

If you enter the start date for a month automatically created daily view for months.

30

autofilter_og_kopier_til_relevante_ark.xls

No

Autofiltrer and udkopierer to sheet and name these

31

autofilter_og_ovf_til_ark_iht_kriterier_i_koden.xls


Autofiltrer according to criteria in the code and place in the appropriate sheet

32

autofilter_resultat_i_ark.xls


Status line text into the worksheet ifm auto filter

33

autofilterresultat_print.xls

No

Automatically prints all the unique set of data in an auto filter-ranked area.

34

autofiltrer_og_print_hvert_resultat.xls

No

Creates an auto filter and print the results one by one

35

automatisk_cellevalg_een_plus_fem.xls

No

Automatic cell marker - The associated VBA code in this example will allow the selection of one cell also automatically select the 5 cells located to the right of the originally selected cell in Sheet1

36

automatisk_dato_sortering_ved_indtastning.xls

No

Date sort in connection with the entry in Column A - The associated VBA code will in this example automatically sort the entered dates for they are typed

37

baggrundsfarve_iht_cellevaerdi.xls

No

Cell background color according to cell value - The corresponding VBA code will in this example give each cell a background color depending on whether the cell's value is above or below 100 in the selected area in sheets1 (yellow background if the cell value of 100)

38

baggrundsfarve_iht_ugedag.xls

No

Colour coding of dates according to the day they are - the associated VBA code will in this example color dates entered according to the day they represent

39

begraens_antal_tegn_pr_celle.xls

No

Limit the number of characters in the cell for 20 - corresponding VBA code will in this instance restrict input't in encelle to 20 characters

40

beregn_hver_3_min.xls

No

Recalculate automatically every 3 minutes - The corresponding VBA code will in this example make it possible to re-calculate every 3 minutes

41

beregn_opsparing.xls


Calculate your savings final amount according to your data

42

beregning_af_arbejdstid_plus_minus.xls


Calculation of plus or minus in working

43

beregning_af_laan_fast_ydelse.xls


Loan Calculator

44

besked_hvis_cellevaerdi_overskrides.xls

No

Notify user if a cell's value exceeds the max. - The associated VBA code will in this example, notify the user if the cell value in the formula in cell A1 exceeds the value 10

45

beskyt_ark.xls

No

Exclude functions from being made ​​into sheets - The associated VBA code will in this example makes the following entries were made ​​in sheets1 {F5} move to '+ {right} Shift right' + {down} Shift down {PgUp} page up '+ {PgUp} Shift page-up' ^ a Ctrl a selection code can be repealed by running the set up for vba code

46

beskyt_og_ubeskyt_ark_med_password.xls


Sheet protection on and off with your password

47

betinget_farve_af_celle_iht_vaerdi.xls

No

Color Control Marking cell (about 3 seconds) - The associated VBA code will in this example do to cell B1 will be highlighted in yellow for a moment depending on whether the value in cell A1 is ligcelle B1 or not

48

betinget_format.xls

Yes

Example of Excel's own data validation. A date is written in red or black, depending on the relationship to date.

49

betinget_konvertering_til_html.xls

No

Conversion to html according to cell value - The corresponding VBA code will in this example convert rows with "alan" in a html file

50

betinget_kopiering_af_kol.xls

No

Move X-selected rows to sheets2 - The associated VBA code will in this example, move the rows in sheet1 which is marked with an X (in columns E) to sheets2

51

bil_benzin_regnskab.xls


Objective: Summary of fuel economy

52

billede_iht_cellevaerdi.xls

No

Add provided according to the cell value - The corresponding VBA code will in this example make it possible to indføjeet provided (in kol.B) depending on the value of the cell (in kol.A)

53

blinkende_celle.xls

No

Flashing cell - the associated VBA code in this example will do to a cell blinkerdvs switches between two background colors

54

bruger_inddata-kontrol_3_eks.xls

No

Via a button in the sheet "Sheet1" activated three examples of management of user input; namely the number of characters that can be entered in a field that a figure entered my. is a given value and, finally, that the format is entered can be read by Excel as a date

55

bruger_input_kontrol.xls

Yes

In this example, only the program's own form form data validation to control input.

56

bruger_input_udskrivningsomraade.xls

No

User Abandoned printing area - the associated VBA code in this example will prompt the user for rest-Ket area to be printed via an input box. Limited to and medkol. In but NOT limited number of

57

bruger_orientering_i_statusbar.xls


Notify the user about the macro process

58

brugerdef_soeg_og_find_markering.xls

No

Search for the user provides and select the

59

brugerindtast_og_slet_data.xls

No

The user can enter / change / delete data in a database "database" which is located in an excel sheet by clicking a button in the "Demo" sheet in a file. Input occurs via a user form which in the example can be entered / changed / deleted in 4 different fields

60

brugernavn_i_det_aktive_vindue.xls

No

The user's name is written into the active window at the top left

61

byt_vaerdi_mellem_to_celler.xls

No

Swapping the values ​​of two cells

62

celle_a1_skal_udfyldes_foerst.xls

No

No entry is done BEFORE cell A1 is - the associated VBA code in this example will make that can not be in-typed data in the sheet BEFORE cell A1 is populated with data

63

celle_eller_omraade_udelades_ved_udskrivning.xls

No

Exclude a field in connection with printing - the associated VBA code in this example will allow the use-clean omitting an area related to printing

64

celle_fed_hvis_negativ.xls

No

Well, exaggeration should promote understanding, but in this case these are different ways of reaching the target, so .... choose the way that is best for you.

65

celle_fed_hvis_negativ_2.xls

No

Well, exaggeration should promote understanding, but in this case these are different ways of reaching the target, so .... choose the way that is best for you.

66

celle_fed_hvis_negativ_3.xls

No

Well, exaggeration should promote understanding, but in this case these are different ways of reaching the target, so .... choose the way that is best for you.

67

celle_fed_hvis_negativ_4.xls

No

Well, exaggeration should promote understanding, but in this case these are different ways of reaching the target, so .... choose the way that is best for you.

68

cellefarve_ved_cursor_bevægelser.xls

No

Colour-coded (yellow) of the active cell - the associated VBA code in this example will make that the active cell is highlighted in YELLOW color

69

cellevaerdi_som_kriterie_i_autofilter.xls


Using a cell value as a criterion in the AutoFilter

70

cellevaerdi_til_tekstboks.xls


Transferred cell content to a text box

73

dage_iht_aar_og_mdr_uden_vba.xls

Yes

Exact dates according to month / year - WITHOUT VBA CODE

75

deaktiver_hhv_aktiver_gem_som_i_menuen.xls

No

Disable or Enable the "File" and "Save As ..." from the menu - the associated VBA code in this example will disable the menu files, Save som.Menupunktet can also genaktives via code

76

debitor_statistik.xls


Simple customer statistics

77

demo_betinget_formattering.xls


DEMO conditional formatting

78

demo_formler_og_funktioner.xls


Demo'r

79

dobbeltklik_aabner_bibliotek.xls

No

Open Windows Explorer from Excel - The associated VBA code in this example will make Windows Explorer open when double-clicked in sheet1

80

drej_en_figur.xls

No

Life is not all "work", so here's a bit of "fun and games" -afd. It has introduced some characters - drawn in excel - in a sheet and a macro makes the figures rotate when you click on them.

81

du_pont_pyramiden.xls


Du Pont Scheme

82

dynamisk_graf_eksempel.xls


Diagram aut. Adjusted number of data

83

ej_rediger_celle_vha_dobbeltklik.xls

No

Prevent editing via double click in the cell - the associated VBA code in this example will make it impossible for the user to edit a cell by double click

84

eks_funktionen_stoerste.xls

Yes

For example, as written, to find a given number of the largest number in a col.

85

eksisterer_biblioteket.xls

No

Checks if a given directory exists

86

eksisterer_det_anvendte_bibliotek.xls

No

Checks if the code listed in the directory exists.

87

eksport_i_csv_format_med_med_komma_i_stedet.xls

No

Export in CSV format but with a comma instead of a semicolon - The associated VBA code in this example will export excelarketsom csv format, but instead of a semicolon as a space character an-inverted comma

88

eksporter_graf_som_GIF.xls

No

A graph in a sheet made ​​into a GIF file - The associated VBA code in this example will make the graph in the sheet Chart1 into a GIF image and import this file instead of the original Chart1 sheet

89

en_liste_over_filnavne.xls

No

Both files makes it possible to find XLS files in libraries, but each in his own way. The first states only up so it can be the current XLS files in the current directory, while the other goes to a compound library specified in vba code "c: / data alan / excel / *. Xls" and counts how many xls files that are then lists them in columns A

90

en_liste_over_filnavne_2.xls

No

Both files makes it possible to find XLS files in libraries, but each in his own way. The first states only up so it can be the current XLS files in the current directory, while the other goes to a compound library specified in vba code "c: / data alan / excel / *. Xls" and counts how many xls files that are then lists them in columns A

91

er_cellen_markeret.xls

No

Checks if a given cell is marked

92

excel_spiller_wav.xls

No

Here you can get Excel to play a music file, as long as the format is * wav.

93

excelark_til_txt_fil.xls

No

This example consists of a sheet with the data in Col. 10 and 10 rows. These are output to a TXT format for future reference. further forarbejdsning there

94

farv_dubletter_og_kopier_dem_til_andet_ark.xls


Select double values ​​with color and copy them to sheets2

95

farv_iht_kundenr.xls

No

If you have Customer instance. in columns A here you will get the color selected all rows with the same Customer with the same color.

96

farve_iht_inddata.xls

No

Colour of entry in Column B according to data in columns A - The associated VBA code will in this example, give your input in Kolb color according to data in columns A

97

farve_overgange.xls

No

Well, how are you "being justified" this, but let's say you have a picture in your excel file in columns A and you want to see what colors the image contains - then running just the macro that will show you the used colors in a cell separately.

98

farvemarker_celler.xls

No

If there is a protocol with many data in it can be difficult to read them. This example color every other cell gray - of course you can choose another color if you want it - in order to facilitate readability.

99

fasthold_indtastningstidspunktet.xls


Captain time of data entry

100

fastlaeg_arknavne_af_hensyn_til_vba_kode.xls

No

Arkkopiering directly naming - The associated VBA code in this example will make the copied sheets are easier to refer to in vba code

101

fejlvaerdier_aendres_til_0.xls


Changes cells with error messages to 0

102

fil_hhv_ark_navn_til_celle.xls

No

File and / or sheet name in cell - The associated VBA code in this example will make it possible to in-put the sheet name in a cell via a custom function or in-put file and sheet name in the same cell

103

fil_spaerring_via_dato.xls

No

Blocking file according to date - the associated VBA code will in this example, make the file can not be opened after a certain date (03.07.2001)

104

filnavn_i_dir_til_html_fil.xls

No

Make a html file with a link to the file names from a directory - the associated VBA code in this example will create an html file of file names in a directory. There are established during a link to each file so it can be opened by clicking on link't.

105

filnavn_og_placering_i_sidefod.xls

No

Filename and location always printed in the footer - the associated VBA code in this example will allow aut.at always get the filename and location printed in the footer when printing

106

filnavn_som_brugerfunktion.xls


File does not work

107

filoplysninger_i_et_ark.xls


File Information Sheets

108

filtrerede_data_kopieres_nyt_ark_med_navn.xls


Filtered data copied to the new sheet called criterion

109

find_bestemt_ark.xls

No

Checks if the code listed in the sheet exists.

110

find_bestemt_fil_i_bestemt_bibliotek.xls

No

Searches for a file a specific place

111

find_celle_iht_koltitel.xls


Search kol.titel mentioned in the code and place the cursor there

112

find_en_bestemt_cellevaerdi.xls

No

Going through the file and find a specific cell value

113

find_hoejeste_dato.xls

No

Sorts and find the highest date in a col

114

find_kol_navne.xls

No

Informs the user which Col. active

115

find_link.xls

No

It can be hard to control herself sometimes when one is started with a "small" spreadsheet. So sometimes it is necessary just to check what other files / sheets referenced in the current file. This example shows this and allows you to delete the chain or not.

116

find_makroens_tidsforbrug.xls

No

Do the time the macro is a throughput

117

find_markerede_kol.xls


Enter the selected protocol

118

find_og_omdoeb_omraader.xls

No

Finder and rename fields in sheets

119

find_og_slet_dubletter_i_kol_a.xls


Do repeating data in columns A and plains of 4 col.

120

find_rabatprocent.xls


Find discount-rate

121

find_raekke_hhv_kol_paa_den_aktuelle_celle.xls

No

Find the address of the cell that is active

122

find_rangorden_af_tal.xls

No

Find ranking of number one versus a series of numbers - the associated VBA code in this example will find rangordensnr. a number in cell B1 in relation to a protocol number in the Kola

123

find_referende_adresse.xls

No

Search for numbers in sheet1 and enter ref.adr. the cell in sheets2

124

find_udskriftsomraade.xls

No

Example where one via vba code automatically detects the connected area to be printed.

125

fjern_formler_med_fejlmeddelelser.xls

No

Remove formulas with error values

126

fjern_gengangere_i_raekker_nedenunder.xls

No

Deletes repeated data in cells below

127

fjern_tomme_raekker_hhv_kol.xls


Remove blank rows and col

128

flere_linier_tekst_i_een_celle.xls

No

Insert text consisting of multiple lines in one cell

129

flextids_opgoerelse.xls


Calculation of current flexitime's surplus / deficit

130

flyt_data_mellem_ark_og_tom_linie.xls


Copy the data from Sheet1 to sheets2 and insert a blank line

131

flyt_fil_mellem_biblioteker.xls

No

The user can move a file between directories listed in the code

132

flyt_fortegnsplacering_til_excel.xls

No

Sometimes when data is exported from accounting systems are negative numbers so 1.000,00- Excel can not summarize these as this program moves minusset to -1000.00.

133

forbind_cellerne_a1_og_a2.xls

No

Combining the values ​​in the cells

134

forbind_og_slet_data.xls

No

Finds and deletes data

135

fordel_data_ud_i_ark_iht_dato.xls

No

Transferred data from Sheet1 to the relevant sheets according to the data - the associated VBA code will in this example udsplitte data from ark1til the relevant sheet in the file

136

forfatternavn_i_fil_via_brugerdef_funktion.xls

No

Insert author name in the file via Custom. Function - The associated VBA code will in this example, enter the author's name in a cell in the file via a custom function

137

forhindre_indtastning_i_givet_omraade.xls

No

Barring entry in a given area in a sheet - The associated VBA code will in this instance thwarting indtastningi range A1: K10 in sheets1

138

formater_til_tekst.xls

No

Change the format of numbers to text

139

formel_vises_i_nabocelle.xls

No

Via a user function, it is possible to display a formula in the example. cell A10 in cell B10 by specifying the function in the last cell (B10).

140

fpostprn_300901_med_opdelingsmakro.xls


Breakdown of balance sheet accounts such as

141

fra_ark_til_ark_via_makro.xls

No

Browse from sheet to sheet in a file via macro

142

fra_formel_til_vaerdi.xls


Convert from formula to value

143

fremhaev_raekke_hvori_cursor_er.xls

No

Marking the range in which the cursor is - The associated VBA code will in this example, select the entire row in which the cursor is

144

gang_iht_cellevaerdi.xls


Multiply cell values ​​by a factor mentioned in the code

145

gem_aktuelt_ark_under_dags_dato.xls

No

Saves the current sheet from the file with dd

146

gem_ark_i_ny_brugerbestemt_bibliotek_mv.xls

No

Saves each sheet as a file where the user wants it

147

gem_fil_i_to_biblioteker_iht_kode_og_bruger.xls

No

Saves the file in the original library and another according to the user - the associated VBA code will in this example, save the file in detaktuelle library and allow the user to select another file which also saved

148

gem_fil_iht_celleindhold.xls

No

Saves the file under the name in cell A1 in Sheet1 - The associated VBA code will in this example, save the file under detnavn which is in cell A1 in Sheet1

149

gem_fil_med_foreslaaet_navn.xls

No

In the first example, the file is saved without notice to the user. In Example 2, the file is saved under a proposed name including date included.

150

gem_fil_med_sikkerhedskopi_i_specielt_directory.xls

No

Save the file and make a backup copy of the special library - The associated VBA code will in this example, save the file where you want it and at the same time save a backup copy in a special library man-tek mentioned in the code. Here c: \ alan \ backup copy \

151

gem_med_vaerdier.xls

No

Saves the current file under another name and with values ​​- The associated VBA code in this example will save the current file under a different name and all formulas, etc. are converted to values

152

gem_sikkerhedskopi_version_af_fil.xls

No

Save a backup of the current file or all open - the associated VBA code in this example will save a copy of entenden current file or all open files in the directory specified in the code

153

gem_uden_alerts.xls

No

In the first example, the file is saved without notice to the user. In Example 2, the file is saved under a proposed name including date included.

154

generer_vilkaarlige_tal_uden_gentagelser.xls

No

Generate random numbers without repetition

155

gennemgaa_hvert_ark_i_fil.xls

No

Are all combinations from a list in a cow

156

gaa_til_forrige_ark_via_makro.xls


Goes to the previous sheet in accordance with the code

157

hak_i_celle.xls

No

Put a tick (check mark) in the cell according to the "box" - The associated VBA code in this example will make a checkhak in cell

158

holdopstilling.xls

No

Are all combinations from a list in a col

160

husk_tidligere_aktive_celle.xls

No

Remember the cell you move from

161

hveranden_raekke_med_fed.xls

No

Every second row is highlighted in bold in order to facilitate readability

162

hvis_fed_laegges_tallene_sammen.xls

No

Adds all the numbers together that are formatted in BOLD - The associated VBA code will in this example, create a user-defined function that places all numbers that are formatted with the Fed - the one given on-advise - together

163

ikke_sammenhaengende_omraade_vaelges_via_vba.xls


Do not choose contiguous areas through macro

164

ikonlinie.xls

No

When I with - unfortunately - periodically must re-establish my PC, I have found the smartest to make this little program that gets "my" additions to the icon line easily and quickly into place every time.

165

import_fra_txt-fil_til_bestemte_celler.xls


Import from * txt file to specific cells

166

importer_en_txt_fil.xls

No

2 examples of importing a text file. In the first example, this is done without the user may provide any of the other user has control over the situation.

167

importer_en_txt_fil_2.xls

No

2 examples of importing a text file. In the first example, this is done without the user may provide any of the other user has control over the situation.

168

importeret_streng_til_tal_format.xls


Change the imported text to numbers

169

inddata-kontrol.xls


Control of the user's input

170

indeks_10_&_12_&_31_og_ryg_sedler.xls

Yes

Print Separator, rygfaner etc. A4 ring binder - no vba code

171

indlaes_autokorrekturlisten.xls

No

Loading AutoCorrect list on a sheet

172

indlaes_filer_fra_harddisk.xls

No

Loading all files in a given directory to a sheet

173

indsaet_autofilter_i_flere_ark.xls

No

Inserts auto filter in multiple sheets at once

174

indsaet_formel_der_ganger_kol_A_og_B_i_kol_C.xls

No

Insert formula in col C that multiplies kol kol A with B - The associated VBA code in this example will insert a formula in kolC that multiplies the value in Column A with the value in Column B

175

indsaet_raekke_under_aktiv_celle.xls


Inserts a new row BELOW the active cell

176

indsaet_subtotaler_ved_dobbeltklik.xls

No

Insert subtotal in the cell is double-clicked - the corresponding VBA code will in this example, insert a subtotal in the cell is double-clicked. Double-click again and subtotal removal

177

indskriv_data_i_valgte_raekker_via_inputbox.xls

No

Inserts data in specific rows

178

indskriv_i_alle_ark_paa_een_gang.xls

No

Enter a text in all sheets at once

179

indtast_loebende_og_gem_tidligere_data.xls

No

Enter the current data to cell A1 but remember past data - The associated VBA code will in this example keep track of which datader previously been in cell A1

180

indtast_password.xls


Checking password

181

ingen_tomme_raekker.xls


Avoid blank rows in the list

182

input_omraade_til_udskrivning.xls


Custom print area via input boxes

183

input_tal_ganges_automatisk_med_given_faktor.xls

No

Entered number is multiplied automatically by 5 - The associated VBA code will in this example automatically times the input number by 5 before it is inserted into the cell

184

integer_talvaerdi_kontrol.xls

No

Checking if a number is a "Integer" value - the associated VBA code will in this example via a custom function to check whether a number is a "Integer" value

186

j_for_JA_n_for_NEJ.xls

No

Upon detection of respectively j write YES and NO n written in columns A - The associated VBA code in this example will do that when enter-ing of the "J" or "n" writing YES or NO in the cell. The effect is limited to Col. A

187

kald_vba-kode_og_slet_den.xls


Call up a vba code and delete it

188

kasserapport_demo.xls


Demo sheet / file

189

kilde_aj1.xls


Copies a region from the active file to a new file with a blank line

190

kildemappe_1.xls

No

See file 223

191

kildemappe_2.xls

No

See file 223

192

kilometer_penge_udb.xls

Yes

Help for you if you regularly pay a mileage allowance to the same people for more or less the same distance

193

klar_til_brugerens_sortering.xls

No

Make the user aware to be sorted

194

koerte_KM.xls

No

Calculating mileage on time etc.. - No vba code

195

kol_til_tekstfil.xls


Export Col. content to text file

196

kombiner_2_ark_til_et_tredie_uden_gentagelser.xls


Combines sheets1 and sheets2 data to Sheet3 without repetitions

197

kontrol_af_ark_i_filen.xls

No

Checks on the list in a sheet set sheet is in the file

198

kontrol_af_arktype.xls

No

Check if it's a plain sheet or a sheet

199

kontrol_af_cpr_nr.xls


Checking cpr.nr - check digit

200

konverter_et_omaades_tal_til_tilfaeldige_tal.xls

No

Generation of case numbers in an area - the associated VBA code will in this example, multiplying the numbers in the selected area with a random number between 1 and 2 and anføreresultatet in the cell instead of the figure originally stood

201

konverter_til_romertal.xls

No

Similar effect as when converting to checktal, but here just from ordinary numbers to Roman numerals as "XXVI".

202

konverter_til_URL's.xls


Convert to URL's

204

kopier_ark_X_antal_gange.xls

No

Copies the current sheet x-number of times

205

kopier_direkte_udvalgte_omraader_til_ark2.xls


Transfer the selected cell values

206

kopier_fil_fra_et_dir_til_et_andet.xls

No

Copies between libraries and checks whether the file is already

207

kopier_filtrerede_data.xls

No

Copy filtered data to either a new sheet or to a new file.

208

kopier_formel_i_kol_B_iht_antal_raekker_i_kol A.xls


Copies a formula in Column B according to the number of rows in columns A

209

kopier_fra_ark1_til_ark2_uden_dubletter.xls

No

Copy the data from Sheet1 Column A to sheets2 without including duplicates - The associated VBA code in this example will copy the data from Sheet1, Column A to sheets2 without including duplicates from Sheet1

210

kopier_givet_omraade_til_ny_fil.xls

No

Copy the selected area to the new file

211

kopier_kol_ved_dobbeltklik_til_andet_ark.xls

No

On double-click transferring data from Sheet1 to sheets2 - The associated VBA code in this example will make it possible by double-clicking a cell in Sheet1, Kola to transfer the data in the row to sheets2

212

kopier_mellem_ark.xls

No

Copying certain data to a new file as the last sheet

213

kopier_mellem_ark_bestemt_antal_data.xls

No

Copy the specified number of data between sheets

214

kopier_og_slet_specielle_ord.xls


Clears / copy data with the letter "a" in

215

kopier_synlige_celler_kun.xls

No

Copies only the visible cells to another sheet

216

kopier_til_nyt_ark_og_list_med_reference_til_celler.xls

No

List duplicates with reference to where they are in the sheet - the associated VBA code will in this example, make a list of duplicate-ing in a new sheet with reference to the cell duplicates are in

217

kopier_vaerdi_af_a1_ud_i_celler.xls

No

Copies A1 value into multiple cells

218

kopiere_dobbeltforekomster_til_nyt_ark.xls

No

Copies repeating data to a new sheet

219

kopiere_fra_omraade_til_omraade_iht_koden.xls


Copies one area to another area mentioned directly in the code

220

kopiering_af_hveranden_raekke_iht_brugerstartdef.xls


Copying every other row, starting row selected by the user

221

kopiering_ala_transponering_af_data.xls

No

Transpose data from Sheet1 to sheets2 with a blank line between - the associated VBA code in this example will copy the data from Sheet1 derstår in the range A1: D7 to sheets2 where they appear in one col (col. A) with entom line between each data

222

kopiering_iht_tal_og_tekst.xls


Copies according to two criteria, numbers and text

223

kopiering_incl_raekke_kol_formater.xls

No

Copying data incl format in a row and col

224

kriterie_kopiering_mellem_2_ark.xls

No

Copying from one sheet to another according to criteria

225

kun_arknavnet_til_celle_i_arket.xls

No

The sheet name appears in a cell in the sheet - the associated VBA code will in this example, create a user-defined function that makes it possible to ONLY get the sheet name to stand in a cell

227

lav_aut_emailadr_UDEN_VBA_KODE.xls

Yes

Auto Generation of e-mail addresses - WITHOUT VBA CODE

228

lav_en_farvepalette_og_vaelg_fra_denne.xls

No

Call color palette - The associated VBA code will in this example, make a color palette and allow selection from this

229

lav_hyperlinks_til_filer_i_bibliotek.xls


Create links to files

230

lav_hyperlinks_til_filer_i_et_dir.xls


Low htm page with links to files

231

lav_vilkaarlige_saetninger.xls

No

Make small arbitrary sentences

232

list_all_kombinationer_af_karakterer.xls


List all possible combinations of characters

233

list_excel_filer_i_dir.xls

No

Overview * xls files in the current directory - the associated VBA code in this example will load a list of file names on the excel files in the current directory

234

list_farver_og_indeksnr_derpaa.xls

No

Overview of Excel's color code no

235

list_filnavn_og_alle_ark_i_filen.xls


Purpose: List Filename and all sheets in the file in the worksheet "Contents"

236

list_skrifttyper_i_excel.xls

No

Make a list of fonts available in Excel - The associated VBA code will in this example, make a list of the fonts that are available in Excel. The list is made in Sheet1, Col. A

237

list_underbiblioteker.xls


Enter a library and get list'd subdirectories

238

liste_over_installerede_fonte.xls

No

Smart little tool for Excel that provides an overview of all the pc'n installed fonts in a sheet.

239

listeeks_mellem_to_filer_HER_FIL_1.xls

Yes

Displays the list box used between two files where one file has the basic information and file two list box.

240

listeeks_mellem_to_filer_HER_FIL_2.xls

Yes

Displays the list box used between two files where one file has the basic information and file two list box.

241

loebende_sortering_ved_indtastning.xls

No

Auto sorting by input - The associated VBA code in this example will automatically sort the data in sheet1 with each input. There is sorted according to Col. A.

242

log_dato_og_tid_for_lukning_af_filen_i_ark.xls


Log time of closing the file

243

lottotal.xls

No

Try your luck, this file automatically generates lottery numbers - no profit guarantee of course.

244

luk_alle_filer_og_evt_excel.xls

No

Closes all files and any Excel

245

luk_fil_efter_10_sekunder.xls


Save the file in 10 seconds

246

luk_fil_med_og_uden_gem_foerst.xls

No

Close the file with or without GEM

247

luk_og_slet_fil.xls

No

Closes the file and delete it then from hard disk

248

luk_sluk_computeren.xls

No

Macro that when run shuts down the computer - the associated VBA code will in this example, shut down the computer

249

luk_windows_ned.xls

No

Close Windows from Excel through macro - The associated VBA code will in this example, shut down Windows

250

lyd_alarm.xls

No

Well, we've all been subjected to "strange users" - if only for ourselves at the start - but here you can give a verbal help or ...... .. the user is doing something in your sheets.

251

lynkopiering_af_fil.xls


Lynkopiering file

252

makroimport_af_txt fil_med_semikolon.xls

No

Macro Text Import CSV file - The associated VBA code in this example will ensure that the macro impor-format text file even used a semicolon as a delimiter

253

makrostart_afhaenger_af_formelvaerdi.xls

No

Start macro in accordance with a formal value - The corresponding VBA code will in this example gøredet possible to start a macro depending on the formal value. If B1 is greater than 10 started the macro

254

makrostart_ved_hjaelp_af_tal-ENTER_tasten.xls


Start the macro by using the ENTER key on the numeric keypad

255

maksimalvaerdi._kolB_vises_loebende_i_kol_A.xls

No

Show the strøste value in columns B standing in columns A - The associated VBA code in this example will show the highest value from col B standing in columns A while entering

256

manipuler_fildato.xls

No

Changes file date according to the user's choice

257

marker_celle_med_stoerste_vaerdi.xls

No

Selects the cell with the largest value, see File No. 131

258

marker_celler_med_roed_skriftfarve.xls

No

Selecting Cells in red color - the associated VBA code will in this example, select all the cells that have RED font color

259

marker_celler_til_hoejre.xls

No

Marking the cells to the right of the active cell

260

marker_loer-_og_soendage.xls


Select Saturdays and Sundays in the list

261

marker_maksimal_vaerdi_i_raekke.xls

No

Selects the cell with the maximum, see 129

262

marker_paa_print_hvis_cellenote_og_export_til_ark2.xls

No

Checking whether there is any cell notes and export of these to sheets2 - The corresponding VBA code will in this example, check the printout whether there are notes in the cell among the cells that are in the selected area. Powered another macro cell are exported notes - with referenceadr. - To sheets2

263

marker_raekker_iht_bruger.xls

No

Marks a given number of rows according to user input

264

meddel_bruger_om_aktive_ark.xls

No

Tells the user which sheets are active

266

maal_aj1.xls


Copies a region from the active file to a new file with a blank line

267

maalfil.xls

No

Copying certain data to a new file as the last sheet

268

maanedsark_med_inputbegraensning.xls


Inserts 12 månedsark and restricts entry of these

269

nem_dato_indtastning.xls

No

Easy Date Entry - The associated VBA code in this example will make it easy to enter dates. Try typing 1-4 in sheets1 in Kola and see what happens

270

nem_datoindtastning_3.xls

No

Easy date entry 3 - The associated VBA code in this example will make the user need only enter the first 2 digits in the date after which the monthly and year-century automatically added

271

nem_tidsindtastning_2.xls

No

Conversion of numeric data to the time format m: ss, 00 - The associated VBA code in this example will modify an entered number format for the above time format

272

noegletals_formler.xls


Summary of economic indicators

273

nogen_aftaler_i_dag.xls


List of possible agreements

274

nummerering_i_sidefod_side_x_af_x_sider.xls


Sidepaginering

275

omraadenavne_til_kommentarfelt.xls

No

Moves the field names to the comment field

276

opdel_hyperlink.xls


Converting hyperlink's

277

opdel_iht_plustegn.xls


Find data in relation to the "+"

278

opdel_tekst_i_karakterer.xls

No

Splits a given text in different character / letter of each new cell

279

opdeling_pr_5_karakterer.xls


Splitting the data entered

280

opslag_fra_ark1_til_ark2.xls


AutoFill

281

ovf_hhv_kopier_kun_talformat.xls


Copies ONLY numbers of cells WITHOUT their color format such

282

ovf_kun_ved_numeriske_vaerdi_i_kol_A.xls


Copies if col A has a numerical value

283

ovf_til_tom_celle_i_andet_ark.xls


Aut above p of the entered data to another sheet

284

personale_kartotek.xls


small løndatabase

285

pivot_konsolidering.xls


I got the impression that if you're not doing anything in pivot tables in Excel - yes, you are reasonably "YT", so I have tried and will probably continue with more examples later.This is an example of three different products which some accounts are consolidated with the opportunity to see each product figures remain.

286

pivot_til_Graf.xls

Yes

Only where a result of a pivot table be used to produce a graph of.

288

proces_indikator.xls


Many times you have to believe in as a user that something is happening when a macro is running.Here are some examples of how the user more or less enjoyable to be kept informed about what actually happens something "machine". There are some examples of this by using "sliders" that moves, with or without text or information through statusbar'n.

289

projektforloeb.xls

Yes

If you have any tasks or projects with titles, start date, duration and end up in this instance, a "graph" showing the different parts of a graphic way.

290

raekkehoejde_i_cm.xls


Allows you to set the row height in cm

291

referere_direkte_til_et_omraade.xls

No

3 different ways to refer to an area, so you may again choose what suits you best depending on your situation.

292

referere_til_et_omraade_vha_Cells.xls

No

3 different ways to refer to an area, so you may again choose what suits you best depending on your situation.

293

referere_til_et_omraade_vha_Offset.xls

No

3 different ways to refer to an area, so you may again choose what suits you best depending on your situation.

294

reset_menuer.xls

No

Resetting menu'r after too many changes - the associated VBA code in this example will reset menu'erne tildefaultværdierne

295

roed_eller_groen_cellefarve_ved_aendring_af_cellevaerdi.xls


Change cell color by changing the value

296

sammenfoej_data_med_vba_kode.xls

No

Collector data in columns A and B and delete the orginal data

297

sammenkopiering_af_5_ark.xls


Copy multiple sheets into another

298

sammenlign_data_i_kol_A.xls


Compare data in columns A, the first 20 rows

299

sammenlign_kol_a_og_b_dob_til_c.xls

#I/T

Comparing Column A and B, duplicate data above p to Col. C

300

sammenligning_2_omraader_i_ark.xls

No

Comparison of two areas in the same sheet - The associated VBA code will in this example, create a user-defined function to check if the two areas are similar. If they are equal = True Or if they are unequally FALSE

301

sammenligning_kol_data.xls


Compare the sheets and remove duplicate data

302

send_ark_hver_10_min_med_outlook.xls

No

Email sheets1 every 10 minutes to a recipient via Outlook - The associated VBA code in this example will make it possible to mail sheets1 to one consignee, here alanj@post2.tele.dk

303

send_mail_paa_del_af_ark.xls

No

Send part of sheets per e-mail - The associated VBA code will in this example, sending a portion of a page as email

304

sidste_cellevaerdi_i_kol.xls

No

Two user functions that return the value of the last cell or a row and a col. Is excellent for control in various cases where you "know" the outcome, but would like to check.

305

sidste_cellevaerdi_i_raekke.xls

No

Two user functions that return the value of the last cell or a row and a col. Is excellent for control in various cases where you "know" the outcome, but would like to check.

306

skjul_kol_uden_data_i.xls

No

Remove columns without data in (blank columns) - The associated VBA code in this example will remove blank columns so that only the protocol with the data in the visible

307

skjul_roedt_markerede_celler.xls

No

Hides the cells marked in red in a col

308

slet_alle_tal_og_formler_i_arket.xls

No

Delete all numbers and formulas but not text - The associated VBA code in this example will delete all numbers and formulas but not the text in the sheet. Select the range you want to delete before starting the macro

309

slet_ark_i_filen_iht_liste_i_ark1.xls

No

Deleting given sheets in a file - The associated VBA code will in this example, delete the sheets with the names listed in Sheet1 Column A. Do not forget to mark the area with the names of the sheets to be removed before you start the macro

310

slet_celle_med_bestemt_vaerdi.xls

No

Deletes all cells with a particular value

311

slet_dubletter.xls

No

Widely used small program that deletes rows which reads the same value eg if in Col. A is a series of numbers with the number 10 repeated several times, you can sort by Col. first and then run the macro withdraw all but once the number 10

312

slet_gentagelser_af_vaerdier.xls

No

Clears all cells with the same value

313

slet_tomme_raekker.xls

No

This small example deletes all empty rows in a spreadsheet. Great to use if one has received some rows by mistake in the center of a large or small area and regret it later.

314

soeg_efter_vaerdi_og_anfoer_fundet_med_ref_i_nyt_ark.xls


Search for a particular cell value and indicate it in sheets2 with reference

315

soeg_og_kopier_iht_datoer.xls

No

User Abandoned date range for copying - The associated VBA code in this example will ask the user for a date range and then copy those rows from Sheet1 to sheets2

316

sorter_efter_hypighed_af_data.xls

No

Sorts one protocol according to the number of times a given value occurs

317

sorter_raekker_iht_celles_vaerdi.xls

No

Sorting acc. A cell's contents - the associated VBA code in this example will sort the data in the column whose title is in cell J2, and state criterion in the status bar to the user's orientation

318

sorter_til_andet_ark.xls


Sort the data to another sheet

319

spoerg_bruger_om_arkbeskyttelse_med_password.xls

No

User can protect the sheet according to macro - The associated VBA code will in this example, ask the user if he wants to protect the sheet with or without password

320

start_altid_i_foerste_ark.xls

No

Always start folder with the first sheet as a current sheet - The associated VBA code in this example will make the first sheet in the file is always the sheets are ready for entry by opening the file

321

store_hhv_smaa_bogstaver.xls

No

Change font size between large or small - the associated VBA code in this example will change from uppercase letters to lowercase and vice versa

322

sum_iht_tallets_farve.xls

No

Very simply, all the red and black, and blue data are summed separately.

323

summer_alle_vaerdier_med_kursiv.xls


Summer all figures in italics

324

summer_iht_brugeroenske_iht_inputboks.xls

No

Sums the rows indicated by the user

325

tael_hvis_eksempel.xls

Yes

For example, as written, to summarize a series of numbers according to some criteria.

326

tael_aar_mdr_dg.xls

No

It would create a user function - and the array formula is also used - automatically splits the difference between two dates in years, months and days

327

tal_iht_forbogstaver.xls


Given the initial letter = given number

328

tal_til_dato_konvertering.xls

No

This saves the user to type "- -" hyphens in dates.

329

tekstrotation.xls

No

Reverses the order of text

330

test.xls


Lynkopiering file

331

test_om_fil_eksisterer_aktuelt_bibli.xls

No

Checks if the file exists in the current directory

332

tilfaeldig_fordeling_af_0_og_1.xls

No

The random distribution of numbers

333

tilfoej_mellemrum_mellem_hver_3_karakter.xls


Divide text

334

tilfoej_til_autokorrekturliste.xls


Allows you to add entries to the AutoCorrect list in Excel

335

tilfoej_til_nuvaerende_cellevaerdi.xls


Add characters to the current cell value

336

total_for_vaerdier_af_aarets_mandage_mv.xls


Added up values ​​from all the year, for example. Mondays

337

udlaes_til_txt_fil_med_brugernavn.xls

No

Export data to text file with the user name included - The associated VBA code in this example will output data in columns Atil a TXT file included user name

338

udskriv_arket_for_den_aktuelle_maaned.xls

No

Automatically prints the sheet for the current month - the associated VBA code in this example will always print sheet Forden current month

339

udskriv_bestemte_ark.xls


Expression of sheets to be printed, OFF and ON

340

udskriv_ikke_tomme_raekker.xls

No

Marking every second row - the associated VBA code in this example will make every other row in column A gray.

341

udskriv_kun_specielle_raekker.xls

No

Print only rows with a number 5 in columns A - The corresponding VBA code will do in this example that only rows where there are a number 5 in columns A to be printed

342

udskriv_modularket.xls

No

Prints the module sheet - vba macro text - The associated VBA code will in this example, make it possible to print the module sheet neat and tidy

343

udskriv_navngivet_omraade_via_vba_kode.xls

No

Printing via vba of the named range - the associated VBA code in this example will print the named range from Sheet1 via vba code

344

udskriv_omraade_iht_celle_A1.xls

No

Print area according to the value of cell A1 - The corresponding VBA code will in this example, the print area shown in the cell A1

345

udskriv_omraade_iht_celleindhold.xls


Printing according to the area mentioned in cell

346

udskrivningsomraade_til_foerste_nulvaerdi_i_kol_a.xls

No

Aut. Print Area - The associated VBA code will in this example automatically print an area that is before the first zero value in Column A

347

udsorter_hoejeste_vaerdi_af_et_omraade.xls

No

Out separation the highest value in a range of col A

348

udtraek_tal_hhv_bogstaver_fra_streng.xls


Extract numbers and letters of a string of characters, Custom. Function

349

udvikling_vist_paa_3_maader.xls


Many times you have to believe in as a user that something is happening when a macro is running.Here are some examples of how the user more or less enjoyable to be kept informed about what actually happens something "machine". There are some examples of this by using "sliders" that moves, with or without text or information through statusbar'n.

350

udviklingsindikator_2.xls


Many times you have to believe in as a user that something is happening when a macro is running.Here are some examples of how the user more or less enjoyable to be kept informed about what actually happens something "machine". There are some examples of this by using "sliders" that moves, with or without text or information through statusbar'n.

351

valuta.xls

Yes

See file 229

352

valutakurser_2001.xls

Yes

Overview of the exchange rate from the central bank - the courses available for download via link't in Sheet1 and save the file to a directory on your hard drive. The library must be the same as that where this file is. Straighten out the chains in this file to the file you downloaded in the National Bank from the link above and you can now enter a date in this file and automatically download the courses from the other.

353

variabel_graf_kol.xls

No

How often have you been involved in a situation of having to add a protocol to a graph. This can be fairly difficult, but this example makes it much easier.

354

vend_minus_fortegn.xls

No

Move minus the imported data (back to front) - The associated VBA code in this example will move all minus sign in sheet stands behind the numbers to the front so can be calculated on them in Excel. Is addressed in sheets1, try right sheets2

355

aaben_fil_ved_reference_til_lukket_fil.xls

No

Open enclosed folder via macro - The associated VBA code will in this example, open a closed folder through a macro

#I/T

dato_og_loebende_tid_i_regneark.xls

No

Displays the current date and current time in the spreadsheet

#I/T

kun_grålige_farver_til_rådighed_i_farvepaletten.xls


Only gray tones available in the color palette

#I/T

creditcard_nr_kontrol


The control calculates a given credit card no.