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. Hiding and restoring controls
  2. Bob Phillips
  3. change and ODBC Connection
  4. Not what I want....
  5. SendKeys to open application
  6. The program have the same problem
  7. Outlook express problem..................!
  8. XP macros not working in NT
  9. Capturing current folder path
  10. Javascripting over an Intranet
  11. Dynamic Named Range
  12. Excel file Copy Prevention/Restriction
  13. Function in cell than fill to next 5 column cells.
  14. Uninvited function!!
  15. really remova all VBA code from Workbook
  16. possible to open a closed workbook from a server
  17. I have password protected and now cannot access it...Help
  18. Pagebreak when range does not fit
  19. Custom Toolbars
  20. adding an integer to a string in code
  21. Need to Change ActiveCell
  22. find
  23. Financial Modeling Project
  24. Set Worksheet Name
  25. Event Handler for Controls made "on the run"
  26. Find Heading & Apply Formula
  27. Auto Print Area
  28. Formatting variables
  29. Coding
  30. Force Integer in Inputbox
  31. Cell Value in a MsgBox
  32. dredded Negative or zero values dialog box
  33. Bypassing protection for macros applied to an image
  34. Color formatting with VBA
  35. finding all missing check numbers
  36. Moving shapes with the mouse
  37. Importing pieces of data from multiple files
  38. Xls to Csv -- remove formatting
  39. find a selection bounded by the color gray
  40. Can't insert a Userform
  41. Need Help with Printing multiple sheets
  42. how to copy and paste in a protected worksheet
  43. Transferring data from Access to Excel in VBA very slow
  44. How to close a drop down box in code
  45. Making a variable in userform available in modules
  46. Message box help
  47. UserForm cosmetics...
  48. MultiPage Control problem
  49. Collection of label in a Multipage
  50. .UsableWidth .UsableHeight
  51. Help with a ListBox
  52. Best way to do this:
  53. Importing File greater than 65536
  54. Different usage of range formats, conflict?
  55. Playing .mp3 files based on user input
  56. VBE replace with pattern matching?
  57. Open CSV file
  58. Microsoft Office Spreadsheet 10 or 11 Component
  59. copy data across worksheets and add multiple lines
  60. "IF" Statements with buttons
  61. Recursive Code
  62. subtraction formula
  63. Reducing the size of the Search Dialogue Box
  64. How to verify addresses and zip codes are correct? In bulk...
  65. Webform
  66. Excel VBA Formatting - HELP!!!
  67. Cross sheet reference function
  68. Search code?
  69. Search not found
  70. Assign macro and hyperlink
  71. How to NOT show other screens flashing by when macro runs
  72. How do I embed Affiliate html links in a spreadsheet
  73. Excel lists
  74. how to prevent code running when in a worksheet code
  75. Application.DisplayAlerts = False
  76. Deleting unwanted data by macro or...
  77. nestedif function
  78. Message box help
  79. Change code HELP. Sentence Case
  80. Processing input data
  81. Image to appear on all worksheets if placed on 1 worksheet. POSSIBLE ?
  82. Macro Problems
  83. VSTO Publishing Problem
  84. creating an array from range help
  85. Invalid procedure call or argument error
  86. Pivot Table Worksheets
  87. Reset a commandbutton
  88. Worksheets() Object
  89. Macro Troubles
  90. Quirky, infrequent problem with code
  91. Fantasy Football & Excel VBA
  92. How to execute a macro in a protected worksheet?
  93. Simple Question..if there is such a thing in Excel
  94. Excel is adding "" to my concanteted fields
  95. How to count and group items in a list depending on size of list?
  96. E-mailing a Mail Merge via Excel
  97. .onaction property for controls checkbox
  98. Creating a form- mail merge
  99. Recognize ALT key Pressed
  100. Open a ms project file from excel using vba?
  101. specify default path in dialog open box
  102. Stopping VBA Debug pop up boxes?
  103. printing all charts in the workbook
  104. How to run macro from Add-In when Excel opened workbook?
  105. switching between workbooks...
  106. Macro conflict causing problems
  107. Tom Ogilvy please help : File size getting large
  108. playing mp3 files on user input
  109. Cursor automation
  110. Replacing a value in the string variable
  111. Button Speed
  112. Problem finding merged cells
  113. deleted files
  114. VBA Automation error
  115. Move method trouble with hidden sheet
  116. defining TextToColumns with variable
  117. Help:Find and Display
  118. How can I move the cell pointer down one row in a macro command?
  119. File size getting large
  120. Macro Strategy - "Peeling" Off Sheets
  121. Run time Error '1004: Method 'Cells' of object'_Global' failed
  122. Unexplained/Unknow"Object variable or With block variable not set"
  123. still stuck on days value to year value code
  124. External database
  125. Suggestions on parsing from Excel
  126. Loading data into Excel file from Data table.
  127. Looping filter criteria
  128. Help with Dates
  129. disable alt and control shortcut keys
  130. Returning formatted output from a User defined function
  131. The 1904 Time System
  132. Temporarily Disable/Cancel pivottable refresh
  133. allow user to paste in a protected worksheet without unprotect it
  134. Multiple Instances of Same Listbox
  135. Input to Form during Code Execution
  136. how to set a userform's button caption equal to a variable in the main procedure?
  137. Can you automatically scale text in a graph? I'm hoping there's a way!
  138. how to average a varying amount ou numbers
  139. Is This Embedded in The COUNTIF() function???
  140. Schedule task without Login
  141. How to increase size of image in msocontrolbutton of custom toolba
  142. Application-Defined error for some users...
  143. How to Know Selected Sheets
  144. Help with Col. split
  145. poor macro performance
  146. Formatting an array
  147. Multipage form: Referencing controls on one page
  148. Finding file
  149. How do I sort values only, and leave formats?
  150. Macro and charts
  151. Repost--"Ignore spaces and tabs in word search"
  152. Global 'Lookup' Ideas
  153. Loop + Data validation list + e-mail problem
  154. Data/amounts in spreadsheets are sometimes dim and fade out !
  155. Determine Email App
  156. updating multipage report before each page prints
  157. Carriage return character
  158. E-mailing Forms
  159. Macro no longer working - Don Guillett
  160. Auto enter data from cell above on enter
  161. Highlight the contain of textbox and radio button
  162. Validation Y N N/A
  163. List Box into a cell
  164. Face ID - where can I get a listing
  165. Is ther a better way?
  166. Help: Creating dynamic sql queries in excel
  167. Save file in a new folder, but create folder only if folder doesn't already exist?
  168. reading txt file and copying the lines in new excel file
  169. data validation
  170. Testers for CDO mail code example
  171. Need tweak in program: finding next data
  172. Need tweak in program: finding next data
  173. Deleting Cell Content
  174. Message Box before Save
  175. print pdf's with changing filenames in a macro
  176. Interactive Workbook on Shared Drive
  177. validation list boxes
  178. Rename or move file function
  179. which sheet a loop is valid for-how do you know?
  180. Copy cells from a excel file that filename changes daily.
  181. printer port assignment in macro
  182. My ActiveX control does not respond when i draw it on a excell sheet, using ActiveSheet.OLEObject.Add
  183. Sounds and Title Bar (Userforms)
  184. Find a sum of a combination of cells to equal a value
  185. Search Different Excel Sheets
  186. Search for first empty cell.
  187. getting the column address of an argument to a user defined functi
  188. Convert Excel 2003 XML file to Excel 97
  189. Table from Excel into Outlook
  190. Insert pictures
  191. Condition Formatting in code. How?
  192. Workbook_BeforeSave question
  193. Excel macros
  194. Working with circular references
  195. Ron de Bruin
  196. Cell formula help?
  197. Capture a worksheet in VBA
  198. searching filenames
  199. set code to ALL sheets in workbook ?
  200. Automatically Begin a new email
  201. (Hopefully) Simple Array Pasting question.
  202. Almost there
  203. Send e-mail
  204. Log in with macro
  205. Can i avoid mutiple copy pasting of this code ?
  206. International Excel 4 Macro
  207. Translation to International Excel 4 Macro
  208. Book
  209. Setting values for "TRUE","FALSE" and "#REF!"
  210. Declear which picture I want to show and not?!
  211. Delete every nth column from the worksheet
  212. Statusbar
  213. Run-time error '1004,
  214. Count rows in multiples of 'X' & highlight?
  215. Thank You Simon :)
  216. Sum selected Range and copy to clip board
  217. Send Excel attachment via Lotus Notes
  218. VB Code Corrected Solutions
  219. Macro to extract data and paste to a new sheet
  220. disable autorecover
  221. Bar Cutting Optimization????
  222. error in code when placed in workbook_open
  223. Excel Sheet cell format
  224. AutoDetect the path of the file?
  225. psate values in right click
  226. Declare Worksheet name over multiple modules
  227. Sri NEED HELP - AUTO MAILING THE FILE WHILE CLOSING
  228. Looping
  229. change formula to code function
  230. want to save, print and close wb
  231. Pause to Calc
  232. error in code help
  233. New Spreadsheet Name
  234. user input of a range of cells
  235. Multi-sheet FIND capability
  236. Syntax error?
  237. setting all sheets in workbook to same zoom level?
  238. Error when Target Range is block, not cell in Worksheet_Change Eve
  239. Remove Dashes
  240. VBA Code To find Hardcoded Values in Formula
  241. Origin of Immediate Window messages
  242. Problem with funtion ShowAllData
  243. autorun a macro
  244. calling sounds in VBA for Excel2003
  245. I'm in over my head.
  246. shortening text in cells
  247. Updating Dates to Next Specific Weekday Automatically
  248. If Statement Before Save
  249. Sending Keys from Excel to Internet Explorer
  250. Need tweak in program: finding next data