PDA

View Full Version : Excel Programming


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 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309

  1. Run-time error '-2147417848 (80010108)'
  2. Print Macro
  3. call macro from combo box
  4. Countif formula
  5. Post Excel Charts as ScreenSaver
  6. Pasting cell range to make selections from existing combobox listings
  7. Print Chart from UserForm
  8. text to ROW macro
  9. Closing Excel
  10. Data sort
  11. entering number in Text cells
  12. Links to Tick boxes
  13. Two decimal places
  14. Picking up entries from multiple work sheets
  15. import outlook calender automaticly using vb
  16. Sheet tabs.
  17. Run-time error '424'
  18. What version of Visual Basic w/Office 2001 Mac??
  19. Is there any limit on command length ?
  20. VBA code for Trace Precedents.
  21. How do I IMPLEMENT regular expressions in a script??
  22. send email via excel for action items with overdue status
  23. Password
  24. Find then copy
  25. current region = name
  26. Button Control
  27. Advanced Formula
  28. Filtering unique records with VBA
  29. Button text
  30. Real-time quote on excel Java
  31. Undo after saving the file.
  32. Print Preview using VBA
  33. Data from Input Box overrides cell input validation
  34. Find Row Number against criteria
  35. Excel crashes due to incomplete VBA compilation?
  36. How do I forecast/predict future values ?
  37. Combining a range of cells' contents into 1 cell
  38. How can I put a working Excel Form into html format?
  39. new to macros - How do I create and run one?
  40. button macro
  41. New user with a mortgage formula question
  42. Beginner macro question
  43. Testing two conditions, one over rides the other?
  44. how to detect the ending row?
  45. Populate List Box
  46. Enabling macros for a specific file
  47. Print Active Worksheet
  48. Replace Macro
  49. Deleting Repeated Data
  50. Convert multiple word files to one excel table
  51. Message Box for Macro
  52. Cell Colour
  53. Can you draw lines through the center of cells, using cell numbers as references?
  54. Data from cell a to sheet2 cell a and b
  55. Excel into SQL
  56. Move Cell value to another cell
  57. Linking to restricted workbook
  58. Accessing text written in a text box
  59. Question regarding sorting a column of alphanumeric cells
  60. Find out whether PC is Locked
  61. random numbers
  62. Row Command button location
  63. Print CurrentRegion w/in BeforePrint Event
  64. Problems storing a Collection within a Collection. Is this possible?
  65. Email all in a Column
  66. macro linked to combo box
  67. macro to split and sort to multi worksheets
  68. Excel Via Web Page
  69. user UserForm Universialy
  70. Excel & Access
  71. VBA/Excel - how do I create a user-defined function out of a makro?
  72. Using excel to save clipboard to csv
  73. VBA Macro running on one PC, not another, all settings/versions seem the same
  74. Macro Through Hyperlink
  75. TextToColumns fails in macro
  76. using a dynamic reference cell to copy a range of cells within a data table
  77. Formula for product of two cells?
  78. 2nd Close Workbook after inactivity
  79. Cell data format
  80. VBA- body mass index cal
  81. i need someone to do all the hard work for me!
  82. Phone dialer sheet is attached
  83. Data from one tab to another?
  84. Macro: Copy Paste
  85. Selecting and displaying data
  86. Formula Iterations
  87. I want to learn about VBA
  88. Validation on string?
  89. PERSONAL in multiple user environment
  90. highlight the active row in a range
  91. how get data from list accordingly
  92. Anchor Text to link to multiple websites
  93. Excel vba close workbook after inactivity
  94. Macro to rename an object
  95. Removing keyboard shortcuts
  96. Hyperlink to Specific Sheet
  97. Combo box and option buttons
  98. Problem with Excel PivotCache Recordsets
  99. Last Cell in row + 1
  100. Auto insert date, time & user in columns when data is entered in another column?
  101. event for pivot PageArea changes
  102. Issue with Determining when Checkbox is Null
  103. Show a cell is has an external data source
  104. Small Problem
  105. Determine if Excel is already running...
  106. Place Msgbox away from centre of screen?
  107. Add Ins
  108. Export Access 97 to Excel on multiple worksheets extra sheets produced
  109. Timed macro for printing and exporting
  110. Question about manipulating list box value in VBA
  111. automatic sort
  112. FileSearch or Dir function with Sharepoint problem
  113. data summary
  114. Events on change of row?
  115. Anti hack protect sheet
  116. How to chg lower to upper case in cell?
  117. Data Validation from another XL workbook
  118. Data Validation list
  119. Combo Box Macro?
  120. Active Row after Autofiltering
  121. Copy cell format with visual basic
  122. Speeding up the Execution of an SQL query in a VBA loop?
  123. reference a sheet with variable?
  124. Get date from six weeks ago
  125. Making text fit
  126. Variable Sort using VBA
  127. Converting words into numeric value
  128. Searching for values
  129. add up time
  130. Highlight a Row based on a cell
  131. Change Header from a,b,c, to 1,2,3
  132. Delete Rows if column D and column E contain 0
  133. Macro to change only cells where colorIndex =15
  134. Excel 2007 Error 1004Macros have been disabled
  135. Unlinking Imported Data
  136. Vlookup - Need Help
  137. Problem in searching for a text value in a range
  138. Searching for Varying Text in a Range of Cells
  139. two-dimensional menu
  140. How to flag a change in the spreadsheet
  141. summe column depending of other columns
  142. Trouble closing MS Word document from Excel macro
  143. Print Cells
  144. Selecting and moving a range to a new workbook
  145. Truncate and Insert SQL from EXCEL macro
  146. Limit Selection to a single cell
  147. deleting charts without activating them
  148. QueryTable.add name problem
  149. Delete Duplicate Rows
  150. Password Userform with visiblity.
  151. find the maximum value
  152. Restrict Textbox entry
  153. Extending the Range of 'Target.Address'
  154. Insert a row
  155. MailItem.Show
  156. Searching for value within a sheet's name
  157. Problem with wait/sleep
  158. Arrange and convert excel to text file
  159. Copy All Open Sheets to a new book
  160. Format blocks of cells
  161. Select Range based on cell content
  162. How to copy "command button" to another sheet
  163. Disable functions
  164. insert row, copy formulas, have code example (I think).
  165. how to add help to a macro?
  166. Making MsgBox display Japanese
  167. optionbutton
  168. repeating a formula
  169. evaluate worksheets
  170. command button on/off (show/hide)
  171. consolidation
  172. Staff rota
  173. generate sequential numbers with a limit
  174. File, Edit, View etc
  175. creating a frequency histogram in VBA
  176. Running a macro each time certain cell content is changed
  177. Save File using Macros / VBA
  178. Cursor Movement (Code Required)
  179. Hide Rows
  180. Creating values for list programmatically.
  181. ActiveX ComboBox selection writes multiple cells
  182. Find Text
  183. Controlling cursor progression
  184. Deleting empty sets of 2 cells in a range
  185. [2003] Excel+VBA: Save old doc to new location/delete previous doc
  186. SaveCopyAs with password support?
  187. Automated search and copy lots of data
  188. row to adjust itself
  189. ComboBox on the worksheet
  190. Webquery via VBA with variable date
  191. Getting "Method 'Range' of Object '_Global Failed" with Range...Select
  192. Return to last page viewed
  193. Sharing worksheets & workbooks
  194. How to lock formula bar?
  195. is nothing
  196. Using MBAXP In Visual Basic
  197. Seach Value
  198. How can i run a VBA macro when a event occurs?
  199. Can't find the error
  200. Code for a timestamp.
  201. macro code to print all or individual records
  202. sorting data using macro in a spreadsheet control object
  203. Can MS Query use excel data within SQL?
  204. delete empty rows
  205. Cancel Button of Message Box
  206. How do I remove comma and all decimals with vba/macro code
  207. custom message box
  208. How to display help text in the Insert function wizard (Excel)
  209. Sheet to sheet copy
  210. Colour Macros
  211. aggregate functions: problem with SELECT SUM()
  212. Cursor Movement
  213. Appending Multiple Text files into one
  214. Sorting ListObjects (tables) in Excel 2007
  215. Looking for a way to move and store a row of data
  216. How to copy data from Access to SQL Server (using VBA)?
  217. Compile Error - Can't find project or Library
  218. CreateTextFile.WriteLine seems to insert double quotes at the beginning and end of ln
  219. Emailing Multiple Recipients
  220. Ho to go back to the original sheet
  221. Macros and protected worksheets
  222. separating data
  223. Web import into array instead of table - possible?
  224. Hide a button
  225. Dynamic Chart
  226. Hyperlink Parsing Starting at "wrong" row
  227. Macro - only want to work if sheet exists
  228. Which is faster: data manipulation in an array or worksheet?
  229. Excel 2k7 Macro issue
  230. Sum across workbooks
  231. Open MS WORD document from Excel macro?
  232. Auto Email From noone inparticular?
  233. macros while editing
  234. How do I stop a Macro after "Cancel" is chosen in an input box?
  235. Don't display blank entries in drop down menu
  236. VB code - compile error box help!!!
  237. Hiding Rows Based based upon cell value being blank
  238. Sort Macro and input Box
  239. Dynamic Print Area
  240. Moving cells of different pages
  241. VBA moving cells value
  242. VBA page names
  243. loop's problem
  244. dynamic row_number
  245. Copy to Columns
  246. copy range
  247. invoice & hours
  248. Drop down with input from other excel book or text file
  249. How do I set a dynamic range based on the column header?
  250. Dynamic reference