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