PDA

View Full Version : Excel Help


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 [34] 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174
  1. Solved: Make range dynamic?!
  2. Solved: Compare multple value
  3. Solved: Vlookup returning all but one value??
  4. how to change column width
  5. If Loop to paste
  6. Open a file
  7. Need macro to delete module content
  8. Copy / Paste down
  9. Solved: User form numeric value
  10. User Form HELP
  11. Grocery lists
  12. Solved: Input box - force certain no of characters?
  13. How make ?hint? to every picture (as button) on Sheet?
  14. make the characters in password entry "*"
  15. Options for triggering macro?
  16. Solved: Delete row if object NOT found
  17. Solved: Put cell values into array
  18. Solved: File Property
  19. Transforming a doc content to Excel Table??!!Help!
  20. Solved: User form problem
  21. Solved: User Form
  22. Solved: Another userform problem - frames
  23. VBA Code for Excel sheet access denied
  24. Solved: Range autofill
  25. Count Values in List, Display Top x
  26. Trouble Closing File
  27. Delete duplicates and sum values macro
  28. select issue
  29. Solved: Transparent Toggle Button
  30. Solved: Code location issues
  31. Solved: User Id And Time Of Data Entry
  32. Solved: Run-time error 1004 ... What am I missing?
  33. Solved: Error Message
  34. Passing a Parameter from Word to Excel
  35. Select duplicates rows in a new sheet
  36. How to specify a formula for a cell?
  37. Comboboxes and VBA i excel
  38. Solved: Lookup in VBA creating Errors
  39. sever all ties & links
  40. How to tell when the 'Notify' option is selected?
  41. NEWBIE TO EXCEL FORMATTING
  42. Solved: Trying to set a cell color from a UDF _not_ a sub()
  43. Solved: Date/time format change with macro...
  44. Solved: Error on opening workbook on another computer.
  45. Word doc embedded object
  46. Solved: Excel Range for Chart
  47. Create on the fly goto sheet form
  48. Solved: Formula in whole column
  49. Can AutoFilter work with Colour based selection in Excel 2002?
  50. Is it possible to create linked cells/aliases for cells?
  51. MSFlexgrid merge cells
  52. Userform auto-size
  53. Draw a line
  54. force excel to autosave
  55. Solved: Find by cell format
  56. Reading data from a database without putting the value to any cell
  57. Open Print Properties using VBA
  58. Solved: Do not paste information on hidden row
  59. Solved: Add extra characters in all cells in column
  60. Solved: Opening a file via macro
  61. Solved: Version control woes
  62. Solved: Runtime Error 9 - Subscript Out of Range - I must be missing something...
  63. Why my Excel program doesn't work on other computer? Why?
  64. Email and Font and color issue
  65. Solved: Multiple Users input updating Master
  66. [SOLVED:] Finding date in a range
  67. Formating range of cells
  68. macro & vlookup
  69. VBA Converters for Excel 95
  70. Solved: optionbutton to set commandbutton focus
  71. Adding a menu to 2007
  72. Excel VBA
  73. Compile Error in MS Excel 2007
  74. Solved: How To Find Text In Excel 2007 Binary Saved Workbooks...
  75. Solved: Loop to check numeric in userform textbox
  76. Losing last line when readig ASCII file into Array
  77. how to copy 2 sheets from a ws to another ws
  78. Calculation based on 2 different columns and 3 different rows
  79. Continually check for next row, or check once & increment?
  80. code for inserting & Copying rows
  81. file rename in vba
  82. Solved: Fill Color issues
  83. Help needed with excel macro problem!
  84. Use of Randomize statement
  85. Solved: Group rows
  86. shift on copy or paste
  87. Excel Outlook Files
  88. Overcome Excel "Save as"
  89. Clear protected cells
  90. Solved: Skip Missing Worksheets
  91. Closing Excel
  92. [SOLVED:] Structure Suggestions?
  93. Copy Named Range
  94. find, copy, delete, paste
  95. Protection - Trial Version
  96. Import data from selected sheets of other wb
  97. Problem launching Excel using code
  98. Solved: (c) copyright - anyway to stop this
  99. Solved: Generating Payslip
  100. Solved: re-using macros and pivotTables
  101. Sleeper: Pivot table Refresh
  102. I want 'sum', not 'count'...
  103. Duplicate or EXTRA rows
  104. Solved: Can I select a Range of Sheets
  105. Solved: Increasing column width
  106. Macro to display who has Spreadsheet open in 'Read Write' mode?
  107. MSFlexgrid alternative
  108. Solved: Quick Question - Easy, but not for me!
  109. SOLVED: Finding #VALUE! as a value
  110. Solved: Quick Newb Question
  111. Comparing data in 2 worksheets & marking them if the respective cells donot match
  112. MS graph question
  113. Dynamic charts
  114. Copy data to Excel
  115. Validation Based On Another Column
  116. Solved: what's wrong with ActiveChart.Export code
  117. Solved: Printing Settings
  118. Open a file from ftp site
  119. Solved: display time
  120. Problem Between Test and Physical Run
  121. Solved: find match copy cells to offset
  122. Solved: Recycle UserForm
  123. Excel VBA - Allow users to choose folder to save file
  124. Importing a CSV and via Userform
  125. Solved: VBA Excel 2003 escape listbox control on worksheet
  126. Solved: Hiding and unhiding rows
  127. Hiding/unhiding worksheets with option buttons
  128. combo boxes pile up when hiding rows
  129. set the security level to "Medium" through vba code
  130. Workign with Image - Should be Simple?
  131. Password entry
  132. How to hide VBA combobox on Excel Sheet when it?s drop down?
  133. INPUT AND RESULT
  134. Solved: Print to non-default printer
  135. Default Number Format for Pivot Table
  136. Pass a variable to a user form
  137. Simple vba for tagging colored cells
  138. [SOLVED:] Registration/ Clocking system
  139. Indexing of custom - type properties
  140. Solved: Cell address : loop till 2006 data
  141. VBA Error Message
  142. Extract Unique Records & Copy to New Worksheets
  143. Solved: codename donot work
  144. Using Sheet1 and Sheet2
  145. Activate a worksheet
  146. Create a control dynamically with an event and progressbar
  147. Name a range with For
  148. Solved: Transpose in diffrent rows
  149. Find lowest bit in an integer
  150. ForcePasteSpecial: getting an error...
  151. [SOLVED:] How to align selected embedded chart?
  152. Solved: Workbook open problem
  153. Looking up Access database
  154. Solved: keeping format when copying
  155. emulate the satuesbar
  156. [SOLVED:] Run Time Error 1004 Select method of range class failed
  157. Not able to assign a whole range as a series to a chart
  158. [SOLVED:] seek help for VLOOKUP
  159. [SLEEPER:] Renaming excel files which have embedded macros
  160. Pivot table in VB
  161. Solved: If duplicate count is
  162. Solved: Problems with my Combo Boxes
  163. [SOLVED:] Setting a filename as a variable
  164. Solved: Minimizing Excel
  165. Solved: Look-up table: Please help me
  166. Excel and Outlook Global Address List
  167. [SOLVED:] Generating Payslip 2
  168. 2-D Vlookup?
  169. [SOLVED:] Text to column macro
  170. Solved: auto email 2 sheets on workbook close, timing problem
  171. Problem with TxtBoxs and MsgBoxes
  172. Always On Top
  173. Multiple CSV Import
  174. Solved: Setting criteria field on autofilter
  175. Inputbox & Time
  176. Solved: Specifying column width in sheet
  177. Help: How to lock sheet but still let macro edit cell
  178. [SOLVED:] Vlookup returning reference values - but only one??
  179. [SOLVED:] How To Convert A Date/Time Serial Number
  180. Solved: Month building code issue
  181. Quick Vlookup Theory Question
  182. Solved: Just a bit stuck
  183. active box on a userform
  184. For Next loop error
  185. holiday form for employees
  186. Solved: Offset help
  187. [SOLVED:] Input specific data into word
  188. Indexing Class Module Properties
  189. Printing different files from a Folder in Excel
  190. VBA Excel Solver
  191. Solved: Can you 'export' a macro?
  192. Solved: Timer
  193. Solved: Can I 'pull in' a worksheet from one excel file into another one?
  194. Solved: How do I?
  195. Click The hyperlink provided in a cell of a table
  196. Solved: Automatically start the macro in 15mins
  197. Checking to see if other sheets are open
  198. UDTs and Collections
  199. Solved: How to password protect the VBA Code
  200. unable to fetch the data from excel sheet based on a given condition.
  201. Sleeper: Auto sorting validation list
  202. Read a Text file with delimiter as comma and import the infor into excel sheet
  203. Returning value needs to be changed.
  204. How do I best integrate and Excel workbook with a website for data capture?
  205. Copy cells from Excel and Paste Special in Word (Clipboard problems)
  206. Do not know how to use "Findnext" command
  207. Solved: Can I 'pull in' a worksheet
  208. Run Time Error 91
  209. Solved: Run-time error 1004 (macro export/import?)
  210. Solved: delete everything other than
  211. Solved: transfer jpg file to Excel
  212. Solved: Help in tabbing
  213. Unlist Table
  214. Restore "lost" custom menus?
  215. Solved: Set range variable to cell above hidden rows
  216. Private ComboBox Event Subs NOT staying private?
  217. finding the Index value
  218. speeding up the code
  219. need to find the cell which intersets the fixed row and a variable column
  220. Solved: GetSaveAs not actually saving?
  221. Time calculation on specific days
  222. Solved: How to run a marquee text in Excel
  223. Creating employee schedules using preferences
  224. Solved: Viewing a text file from within Excel
  225. Sleeper: Text Edit Mode
  226. Solved: automatic convert to upper case
  227. auto add column
  228. [SOLVED:] Syntax for 'LookUp' command? Help...
  229. Solved: Run Macro When Worksheet Is Selected
  230. Solved: VBA Character colour change
  231. Solved: Macro to match name & date and move info
  232. Solved: Toolbar has no label
  233. Solved: Numpty question, but I'm not too proud to ask for help...
  234. how to find the first date?
  235. Solved: Print Multiple Pivot Charts on Single Sheet
  236. Code goes into a infinite loop
  237. Excel UK Conference 2007
  238. Fetching excel data based on a given contd.
  239. Solved: Count Data Then Send To Correct List
  240. Question re Form option/UserForm
  241. multicolumn combobox range
  242. Update records from user form
  243. Copy cell format, formulas, and insert new row
  244. offical excel vba tutorials?
  245. invisible window
  246. VBA regex multiline match not working
  247. Populating Combo boxes
  248. Solved: Updating sheet
  249. [SOLVED:] Gannt Chart
  250. Solved: Problem With Choose & Match