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

  1. Message box pop up for command button
  2. Complex-ish macro including averageing and choosing-data-by-identifier
  3. Does not work if there is only 1 entry in column, works for more than one enteries
  4. Solved: How update tow Chart after import by VBA finish
  5. Solved: AddIn - Unhelpful Error Message - please illuminate!
  6. Loop Issues
  7. Break Text at First Space Before Char 75, Insert Line and Move Char 75+ to New Line
  8. Solved: Pivot Chart Help
  9. Macro to print chart
  10. Is there an Easier way to do this? Sum Sheets based on Name *
  11. connect to the Internet with a click of a button
  12. Solved: finding row and skipping over data
  13. Loop thru FTP sub-folders, downloading, renaming & uploading their files.
  14. Create orders log and monthly report for all orders
  15. External Workbook Lookup and Match
  16. Combining multiple columns into 1 for pivot table
  17. Trying to open Excel 2010, auto-open Excel 2003
  18. I need VBA code to update log worksheet and maintain a history of all orders.
  19. Excel, send emails, vba, question
  20. Run time error '429': ActiveX component can't create object
  21. Compare and delete duplicated data from several columns
  22. Run time error '429': ActiveX component can't create object
  23. Solved: Trouble with copying in a loop...
  24. if find matched data, delete the column data
  25. Automating distribution of emails with excel attachments with VBA
  26. Simple but not for me :(
  27. extracting a single row from a multi row/column range
  28. Solved: If in particular column written text then other column should be numeric
  29. Run Autoit File from Excel File Location
  30. Solved: Auto Fit Selected Row Plus 10
  31. Understanding Code - Check If Named Range Exists
  32. Solved: Interpolation function with empty data
  33. A bit of Help with an array code
  34. Building a Call Tree (work in progress)
  35. Not Copying the Value of an equation from range.
  36. Excel VBA control loop with Find
  37. If formula - Can't get to work properly
  38. Application object names, true, false etc
  39. Solved: Accurate specific cells must be maintained in the concrete columns on another sheet
  40. Solved: Conditional Format
  41. Solved: Parsing an array, calculating cumulative sum and spitting some output
  42. edit vba code for display In Exponential Form
  43. Solved: Subscript out of range when using name of workbook that exists
  44. Solved: If Or Statement
  45. Solved: Rename the name of files
  46. Macro to count words
  47. Solved: Trouble with syntax?
  48. RefreshAll complete event
  49. Help with macro code found on this forum
  50. Solved: Copy and Paste to new row/column IF values exist in paste
  51. Input Box: Ranges...
  52. VBA Macro to Count Rows across Multiple Workbooks
  53. Out of memory when saving file
  54. Solved: Selection.Find Error handling
  55. text help
  56. edit code for display In Exponential
  57. VB Code partially working
  58. Write Res Password - Force ReadOnly unless Macros Enabled
  59. Solved: Mouse over a particular column in ListView to display a message
  60. Solved: Auto-populate column with hyperlink code
  61. Using a variable to as criteria in autofilter
  62. Solved: Renaming modules
  63. Solved: VBA to replace specific alphabets with blanks
  64. Solved: (VBA) Export to .txt only specific columns without empty cells
  65. Kick off macro at 8:15 am central time
  66. Solved: Stepping through Userform VBA code
  67. Find the max and min from a range of cell given a criteria
  68. Solved: Making two cells date and placing them with a hyphen in a cell
  69. Help to extract data between tags in webpage html
  70. loop to fill different cells regarding an Data base
  71. Solver in VBA- Project Dependencies
  72. Show formula and absolut reference
  73. How to code a boolean expression parser?
  74. google spreadsheet help
  75. google spreadsheet help
  76. Solved: copy ranges (tables) separated for separate tabs
  77. hi im new to VBA need some help copy and pasting with a twist.
  78. Look at Sheets that begin with Shop* then see if data exists in Range...
  79. Duplex printing of specific sheets in workbook?
  80. VBA to Add ListItems to a ListView
  81. Application to enter data from columns that are in the various documents
  82. Pivot chart - Auto change Data source
  83. Help with modifying code to look for like sheetnames
  84. textbox color change
  85. Get Data from IE Error ....
  86. Copying columns from multiple sheets to master
  87. Update Multiple workbooks with Master File
  88. vba combobox help
  89. After print event
  90. Open objFile For Input As iFileNum opens only 512 files and fails to open 513th
  91. Help with VB to VBA
  92. Vlookup query
  93. Asking about Using VBA in Excel for Download Financial Data
  94. .txt -> .xls format
  95. Solved: Date Format Problems
  96. Excel Compatibility issue
  97. Solved: What's the use of a class module
  98. Uncheck boxes in one group only
  99. Merging cells based upon values
  100. Find repetition in data values
  101. Formulas into VBA
  102. Page Numbers
  103. Macro to insert batch hyperlinks from external sheet [pics]
  104. Selecting a range based on a date range
  105. Values and Reporting
  106. [SOLVED] Plz help to modify search VBA (Data sheet to another file)
  107. Consolidate Lists
  108. vba code required to help populate emails with details in spreadsheet and send
  109. Color Entire row based on the date
  110. check if a surname is repeated within a cell and output a simpler name
  111. VBA: Multiple Autofill in same column
  112. Autofilter - Worksheet Calculate
  113. Question on Row References in VBA
  114. Solved: Transposing Irregular Data
  115. Help with an Export Macro to Excel
  116. Search
  117. Multiple Actions on each cell in loop
  118. extracting from web
  119. Solved: Use VBA to assign assign code/a macro to a custom button added to a toolbar?it
  120. Solved: text to column question
  121. Drop down problems
  122. Copy\Paste
  123. How to Extract Title from a Text file and Paste to Excel
  124. vba code for remove blank cells
  125. VBA 2010 create PDF from multiple sheets
  126. Help using For Next loop to delete ranges
  127. Combining Spreadsheets by feature
  128. discret convolution
  129. Solved: Averaging figures logged in the AM vs PM hours
  130. Mail attachment through EXCEL
  131. Copy Paste Code
  132. Upon returning research userform,date is reversed MM/dd/yyyy(I.need.DD/mm/yyyy
  133. Help please - very new to this
  134. UserForm to select items from dependent lists
  135. VBA to extract all images from word file
  136. VBA for Investment
  137. Election results
  138. Sum Till Target is Reached
  139. Grouped Cells - show and hide groups in code
  140. Programming help
  141. Solved: cut and paste records based on multiple criteria
  142. Probably an easy question for you VBA pros!
  143. Question on Target.Parent.Active
  144. Help required - please
  145. Efficient Macro - Suggestions
  146. Solved: Filter on matching data in two columns
  147. Solved: Help with labelling of graph
  148. Sending Emails from Excel Via Outlook 2007
  149. Solved: User can only save workbook if completed, or close without saving
  150. turning off calculation on all worksheets
  151. How can I add a file to the playlist of VLC when it's already in use
  152. VBA SetCursosPos with co-ordinates of cell value
  153. Matching Co-Ordinates
  154. Import selected cells from multiple WB's to 1
  155. Solved: double click worksheet event limited to a worksheet range
  156. Scripting Web Form
  157. Solved: Count Unique Values When Filtered
  158. Basic Help: Copy value from one sheet to another
  159. Basic Help: Copy value from one sheet to another
  160. Solved: Error using file on another computer
  161. Need Visual Basic code for macro to select pivot field name indirectly
  162. Browse to a folder and extract all workbook names to a sheet in a workbook
  163. Track and display multiple changes by different users as comment
  164. Excel visual basic (ctrl+click) copying clicked cells to new excell file
  165. Solved: Writing VBA code to loop
  166. finding 12 numbers that'll give me the most result in a row of an array
  167. datatype mismatch in criteria expression
  168. List Folder Based On Search Word
  169. get html img src filenames by Excel VBA
  170. Solved: auto complete based on the first and last name (combobox / UserForm)
  171. Conditional Copy Paste Code
  172. Solved: Looking for values outside of a range
  173. INSTR
  174. Checkout system
  175. Automatically create Combobox
  176. Solved: Understanding Date and Time Formats
  177. Add List value to hyperlink
  178. Need help on reconcile two worksheet
  179. Need a loop script to copy from one 'data' workbook' to a template, make some edits,
  180. Solved: Refering to a specific control in a class object
  181. function operations
  182. Counting Unique Values to Generate a List of the Top X Largest
  183. Solved: RmDir generates File/Path Access Error
  184. Save as csv
  185. GoTo vs Call
  186. Trying to copy current worksheet name
  187. Ommitting Unused Data on Cell
  188. Help with conditional values
  189. Automating tables creation with VBA code
  190. Navigate to WebBrowser problem
  191. Table of content
  192. Run-Time Error '424' Object Required
  193. Solved: For Loop - increase stop counter due to inserting rows ?
  194. Solved: Please explain!!
  195. Solved: VBA Copy and Paste Specific Cells Based On Another Cells Value
  196. Update External Link in Text Box
  197. setting source data for a pivot using variables.
  198. Problem with a loop that compares two columns of data
  199. Solved: Moving data from form to worksheet
  200. Help with form
  201. Combobox dependencies
  202. Simple inserting column then titling
  203. Solved: Transferring data from Excel to Access macro
  204. Solved: I need help edit code hide rows in excel
  205. Solved: Visible Cell .EntireRow.Delete 2010
  206. Solved: For Next help
  207. Solved: Dimension help when closing workbook.
  208. Macro printing to refer to cell and named ranges
  209. Help with vba code
  210. For Each Loop looping to many times
  211. Creating index sheet in excel. Help
  212. Excel formula help to check type of leave and calculating total days
  213. Need help for a macro to match data in excel!
  214. Lock specific columns
  215. Sort by Distance to Each Successive Point
  216. Pivot table help please
  217. How to auto enable circular reference?
  218. Solved: vlookup
  219. VBA loop help
  220. Need macro for taking data from one sheet and autopopulating another
  221. Restricting Save As Options
  222. Solved: Picture Size
  223. Get Data Only from Certain Records
  224. Command Button to combine multiple worksheets into 1 pdf
  225. Pivot Table Field selection
  226. Solved: Is this a good way to check if a cell contains a valid time?
  227. Checkbox - Automatic Copying to Different Sheet
  228. Not really sure how to title this...
  229. VBA to Change Connection String of all query's in a workbook
  230. into string value into range based on lookup in another workbook
  231. macro execuation to delete folders
  232. Search for character within a value (VBA)
  233. Autofilter based on cell from another workbook
  234. Solved: not case-sensitiv alphabetical order for combobox values
  235. VBA Filtering
  236. Calling a function, click a link using VBA
  237. data from another workbook and implementing conditions
  238. userform with option to Copying & Inserting Rows
  239. Solved: Check that an excel file exists
  240. Solved: VBA Help with Copying Data and Formats from Rows
  241. Solved: Filter Range Issue.
  242. [SOLVED] Sort contents in a text file.
  243. vba comments
  244. Solved: Help on selecting unique random words from a list.
  245. Nested Formulas to skip 0's?
  246. Array formula to extract in-between dates
  247. Solved: Help to solve a little mistery
  248. Add digital signature using excel VBA to PDF
  249. Split words in each cell in range and compare to see if in another range
  250. Getting cell coordinate from the last cell with text in it in a ranged row