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

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