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. [SOLVED] Summary Sheet of Data From Other Workbooks
  2. How do I call a UserForm from within a Macro?
  3. Average every four lines
  4. [SOLVED] deleting rows based on criteria
  5. Limiting Constraints in Solver
  6. [SOLVED] What's wrong with this simple ListBox code?
  7. [SOLVED] List Box Scroll Bar
  8. [SOLVED] Code to recognize where selection change active cell originates
  9. [SOLVED] Label Question
  10. [SOLVED] moving between 2 open workbooks
  11. [SOLVED] copy only certain columns
  12. Excel macro to copy and paste onto every nth cell
  13. [SOLVED] Make autofilter react based upon selection in drop box...
  14. Select all textfields in a document and calculate field INCLUDEPICTURE
  15. Hard page breaks being replaced by soft breaks in the wrong place
  16. Checkboxes with linked cell's
  17. Convert sale amounts ..
  18. Scrollbars on a multiline textbox
  19. vba for copy paste to blank cell
  20. linking a common unique value across multiple worksheets
  21. Macro to save file
  22. Search directory
  23. Converting date value to Day of Year
  24. [SOLVED] occurence /count of a cell value in a column/range
  25. [SOLVED] putting spinbuttons in a worksheet
  26. 'Button" Property window not getting displayed
  27. [SOLVED] Code not working on windows97
  28. [SOLVED] combining rows
  29. MapDrive Script Question
  30. cut and paste over referenced cells
  31. Why wont this macro stop?
  32. [SOLVED] How to create a User input dialog box?
  33. Huge Excel with Macro File Size
  34. [SOLVED] How do I macro 20,000+ series of data?
  35. Update hyperlink, update cell
  36. [SOLVED] Checkbox function to add +1 to cell in different sheet
  37. pivot table refresh - error 1004 - reference is not valid
  38. a macro which updates =now() formula for only blank cells
  39. Adding data from form
  40. Find Blank cell in column then Fill Up
  41. [SOLVED] Reversing Sign Based on Cell being Manually Coloured
  42. Create PDFs Using Excel VBA?
  43. [SOLVED] Not exiting For loop
  44. [SOLVED] How to Copy macro to bottom of same sheet
  45. date and then switch
  46. Trouble with macro and button
  47. locking page layout and header and footer options
  48. [SOLVED] Event macro error when selecting more than one cell
  49. [SOLVED] Worksheet change event not responding to cell deletion
  50. relative movement of the cursor
  51. Do Loop with Mulitple Sheet output
  52. Copy Paste section of macro not working in shared file
  53. excel code import
  54. Macro Creating Email formatting
  55. Better than loops
  56. [SOLVED] Trouble with Selection_Change Event
  57. Expanding an array....Interpolation?
  58. excel to oracle
  59. excel to thumb file
  60. Export Data to *.txt or *prn. Text file to have equal field spacing.
  61. [SOLVED] Week Number in Month
  62. Display data from WorkSheet on List Box
  63. Macro to print before saving file
  64. Trouble moving worksheet to new location
  65. [SOLVED] Vlookup Problem
  66. Making PDF's using Excel Macros
  67. Auto Change Screen Resolution
  68. Text Box size programming help
  69. Formatting multiple cells based on cell values
  70. Executing an .exe program with parameters in VBA
  71. Create a button to Email file using LotusNotes
  72. External database query, shifts everything right!
  73. [SOLVED] Recorded macro missing paste commands
  74. Multiple CSV import
  75. Saving when displaying in SharePoint 2007 Page viewer
  76. Looping Through A Range Of Cells
  77. copy method of excel failed'
  78. repairing figures in a column
  79. [SOLVED] Using cell as checkbox (add tick mark)
  80. change column data into row data
  81. Schedule Macro
  82. [SOLVED] Copy Database File And Save to Desktop
  83. Login to PC/Login Script
  84. retrieve title of a column
  85. FileSearch method and filenames with unicode characters
  86. Adding Checkbox functionality to working Userform
  87. ActiveX Excel Workbook Timeout Property?
  88. Delete rows with conditions
  89. Import Query in Access to Excel
  90. [SOLVED] Code Is Deleting Header
  91. Protect Sheet and Still Use Formatting ToolBar
  92. [SOLVED] Run Time Error 438
  93. Linking 2 spreadsheets without using vlookup or range lookup
  94. Macro to automate a tab value search
  95. [SOLVED] VBA- setting id of textbox in macro code
  96. [SOLVED] Opening an excel file from a cell reference
  97. [SOLVED] Folder Creation with a Macro
  98. [SOLVED] Generate Folder
  99. [SOLVED] Cannot eliminate Value Error
  100. Edit All Hyperlinks On A Worksheet
  101. Macro to Auto Update from Internet?
  102. [SOLVED] Can you change form button properties with a macro?
  103. looking for vba excel for comparing 2 columns and adding a formula in a third range
  104. Lose cursor after unloading form
  105. [SOLVED] Code loop through two tables checking and altering
  106. How to ignore strings that don't match a certian format?
  107. [SOLVED] Macro to combine Rows
  108. Display data entered on userform1 to userform2
  109. where is my Menu Strip in VBA?
  110. [SOLVED] How do I initialize a ComboBox?
  111. [SOLVED] Selectionchange event to protect cells
  112. [SOLVED] Excel caught looping script
  113. [SOLVED] Concatenate to include carriage return
  114. averaging velocity time curves
  115. [SOLVED] Filling an Array
  116. [SOLVED] Macro not responding to cell deletion
  117. Excel Shared environment
  118. Clearing a cell
  119. [SOLVED] Run a Btach file from excel
  120. Click for "X"
  121. Creating a Macro Button
  122. [SOLVED] Copying Sheet Including Objects On Sheet
  123. [SOLVED] Script Hiding the last sheet
  124. [SOLVED] Kill Worksheet Code
  125. Javascript on VBA
  126. [SOLVED] copy and paste values based on a criteria
  127. [SOLVED] For Loop Issue
  128. How to allow only numbers in excel 2007?
  129. Setting up the Excel files for Configuring Website Logs
  130. [SOLVED] Same page printed but with changing sequential number on it
  131. Do Loop with variable output
  132. Problems linking cells with a timed macro
  133. How to list all macros in >100 worksheets?
  134. Copy Text
  135. [SOLVED] Adding Sheet Name
  136. Linking Cells in Spreadsheets using a macro
  137. In Workbook running macro with relative path
  138. [SOLVED] Ending Macros
  139. File not found
  140. Sheet Inactive Macro
  141. scheduling a macro
  142. SendKeys & Print Screen
  143. Button the runs a function
  144. Loop Through A Range, Find Cells > 1, Copy Offset To Another Sheet
  145. Copy entire row to new sheet based on value in column
  146. [SOLVED] Generate new document
  147. [SOLVED] VBA to move shape from current cell position to cell 1 row up
  148. [SOLVED] Modify Code to change cell background color
  149. [SOLVED] Odd Background shading behavior And Error Checking
  150. [SOLVED] How to update a 2nd Worksheet from another Worksheet
  151. Private Sub Worksheet_Change stops working when I have certain workbooks open.
  152. [SOLVED] Boolean racking my brain
  153. [SOLVED] Auto Date and Time in A Macro
  154. Hide a checkbox when hiding the row it is in
  155. Index Match, repeated numbers
  156. [SOLVED] limit textbox data to number range with IF statement
  157. [SOLVED] Re-Calc from new cell if so many cells are blank
  158. Turning Display Alerts Off Causes Error
  159. macro; set a report filter value?
  160. [SOLVED] Recursive division Macro Mod needed for Char Type
  161. Excel VB script which locks cell after single use in shared work book
  162. Select Cell Based on Today's Date?
  163. [SOLVED] Error inserting a formula into a cell
  164. [SOLVED] How to Select All Rows in a Macro
  165. [SOLVED] Convert to Number
  166. [SOLVED] Clearing Validation Values based on another validation
  167. [SOLVED] Copying A Cell Value in One Workbook To Another Workbook
  168. Constrained regression using Excel solver
  169. Numerical fields in equation objects
  170. [SOLVED] Check before if Chart object exist
  171. Delete rows whose value beings with space or value
  172. [SOLVED] Importing from one file to another
  173. Get original cell value before calling a UDF
  174. Filtering the cells by colors
  175. Errory while pasting data due to different size of worksheet
  176. Coping a picture
  177. synch data in chart about max value
  178. move data
  179. [SOLVED] Re-calculate worksheet when cell changes!
  180. [SOLVED] VBA: vlookup and return cell reference
  181. [SOLVED] FileSearch always returning zero
  182. Optionbutton defaults
  183. Getting the criterias used for autofilter
  184. Compile error in hidden module: sheet1
  185. Loop instruction for number of lines of data
  186. How to apply Loop to below code
  187. [SOLVED] Open Files Based On Selection
  188. [SOLVED] finding N/A
  189. Using Scroll Wheel on VB Listbox on Sheet causing crash
  190. Find and Offset
  191. Remove All Defined Names
  192. hiding sheets but still letting macros run when printing hidden sheets
  193. [SOLVED] Sort & re-write column data to rows - Excel 2003
  194. delete rows using VBA
  195. [SOLVED] Conditional Validation dropdowns
  196. Textbox to accept 12 digits
  197. Hiding Formula Bar and Column Headings in Excel 2007
  198. InStrRev - Compile Error
  199. Subtracting days
  200. SaveCopyAs Method
  201. [SOLVED] Making one sheet visible once a Week or when command button is pressed
  202. Lost macro password. Is there a solution?
  203. VB Script to change system date and perfrom task
  204. [SOLVED] Is there a scroll over type function ?
  205. Want to pop-up a msg box or read some lines in excel when certain days comes
  206. using the Range function with index values
  207. [SOLVED] copy data based on cell entry to different spreadsheet
  208. Assign Macro To Jpg
  209. [SOLVED] Checking a range for data
  210. Macro To Link Partial Information
  211. Global macro
  212. Collating specific columns from multiple workbooks
  213. Selecting / Copying information from another file.
  214. Recursive formula for all Tabs
  215. Format Cell to Scientific value
  216. Function to select and delete certain rows of a spreadsheet
  217. [SOLVED] Merging sheets based on Entity number.
  218. [SOLVED] Separating and Converting Strings to Range
  219. [SOLVED] Macro to get avearage of variable set of data into another sheet
  220. Inserting image in Excel sheet based on EMP ID
  221. [SOLVED] ZIP Excel File
  222. jump to specific date in cell-range based on last opening of workbook
  223. [SOLVED] How To Loop with below code
  224. Macro for Textbox in Userform
  225. [SOLVED] Named Range Not In DAO Tabledefs Collection
  226. [SOLVED] Hardcode options into list
  227. [SOLVED] How to minimise .Select in Macros?
  228. How do I Split Excel Worksheet into multiple sheets?
  229. [SOLVED] Macro to copy entire row from a selected cell
  230. Counted used rows in a range
  231. Argument Not Optional error on click of Ctrl+V in Excel 2007
  232. [SOLVED] column hide/unhide macro
  233. [SOLVED] VBA code not working when I protect the sheet
  234. Hiding Worksheet on Value
  235. Need to display requested data from Excel to Html
  236. [SOLVED] Email to a list of names from within worksheet
  237. [SOLVED] Determine a cell's format and type
  238. option buttons
  239. Make cell into button
  240. [SOLVED] Transfer Data From Workbook To Workbook
  241. [SOLVED] Consolidate five paired lists into one list
  242. adding two cells from ADO macro
  243. [SOLVED] deleting specific rows
  244. Variable number or rows
  245. ODBC Connection
  246. Personal.xlsb Sheet
  247. [SOLVED] Pull Data from Folder of Workbooks
  248. [SOLVED] Countif Value problem
  249. [SOLVED] Sort and filter range with protected cells
  250. [SOLVED] Protect cells with VB