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 167

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