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 168 169 170 171 172 173

  1. Find and copy
  2. Compare master list to Imported file
  3. Export excel data to word (in table)
  4. Need to Compare any Columns as given by user
  5. Solved: tricky copy and paste macro
  6. Master Formula
  7. Excell macro HELP PLEASE
  8. Replacing old vba code with new help
  9. Solved: Sheet Tabs
  10. How to detect IE modal window?
  11. Solved: Variable Named Ranges
  12. Solved: MaxRow . . . Where Is It Defined??
  13. Solved: Cycle through Collection of Check boxes
  14. automatically convert incorrect data
  15. listbox BeforeDropOrPaste event
  16. Search Entire Workbook
  17. Job Time Problem - further issue ??
  18. UserForm? question
  19. [SOLVED] Select the lastrow using the active cell
  20. Open Excel file via Web Page with Arguments
  21. help with Int and Rnd
  22. Solved: Copy from one workbook to another
  23. Solved: help with vba
  24. functions in vba
  25. Solved: VBA Code for large number of cells in a range
  26. Solved: Adding a new item in menu bar
  27. Solved: macro to edit background colour
  28. Solved: Rows to Columns
  29. Solved: Declare 2 Named Ranges for Cell Properties
  30. delete one row of data
  31. Solved: Minutes and Seconds Validation
  32. Solved: Hyperlink as cell text in a range
  33. Solved: Range instead of Formula...
  34. Solved: Only do if not read only.
  35. Formula Help
  36. extract and compare data from text files through excel vba
  37. Fixing Size of Headers/Footers - print setup
  38. Assign Dynamic Colmumn Reference
  39. Data validation limitation: List source (Run-time error 1004)
  40. Solved: Run macro when spinner value changed
  41. macro to edit table rows
  42. Solved: date footer
  43. Using Vlookup in a userform to display data from search criteria?
  44. Hyperlink SubAddresses lost during Save As
  45. avoid outlook message
  46. Optimising Autofilter macro
  47. How to run excel module from javascripts?
  48. Restrict entry to text onlt
  49. [SOLVED] Using Ranges with CountBlank
  50. Search Directory and Sub Folders Help
  51. Solved: Better understand macros
  52. Solved: Exiting Debugger when there's a constant stream of pop-ups
  53. Formula for finding text
  54. macro tofind the least occurring numbers
  55. Solved: how do do i get my string to appear on the word document
  56. Out of Form
  57. Solved: Excel 2000 to 2003 compatibility issue with .Find
  58. Solved: Error with Date calculation
  59. jump from a cell to another
  60. Solved: Help - Macro to convert column values into row values for various branches
  61. HELP!!! Very Important For-Next Loop
  62. use spreadsheet when running form
  63. Solved: macro to control rows in tables
  64. Solved: macro to clear content and move data one column to the right
  65. Extracting Unique Rows based on multiple colunms
  66. class librarys
  67. Add extra step to current macro to reset table
  68. Solved: Renaming a Range
  69. Solved: Time format validation
  70. Value Paste Macro efficiency
  71. Solved: Run out of screen
  72. Solved: Writing one row to many rows depending of contents in column
  73. Solved: Deleting 0 (zero) from cells
  74. Help with charts
  75. Length of VBA line
  76. passing arguments to forms???
  77. Whats wrong with this code??
  78. Copying Pictures
  79. insert row by date
  80. Solved: VBA Worksheet Project
  81. Deactivated macros
  82. Solved: Moving Data from a form to Excel Spreadsheet
  83. Solved: Help with resize
  84. macro to copy and paste worksheet
  85. Solved: if & vlookup
  86. Using variable in property names
  87. Solved: Langauge problems
  88. VALIDATION PROBLEM
  89. cleaning up sheet/cell references
  90. Solved: Folder picker to output path chosen
  91. Transfering Data To Word
  92. VLookUP to Update List?
  93. Minimizing VBA user form window
  94. Solved: Building Word Documents based on Individual Excel Rows
  95. Goal Line in Bar Graph - Can't get it to work
  96. multiple freeze pains
  97. Hide rows based on data in visible columns only.
  98. Solved: Userform check boxes and controling them.
  99. Solved: Run-time Error '1004'
  100. Wildcard in loop 'until' condition
  101. [SOLVED] Try Catch Block
  102. Solved: Macro to extract Word Info works in Word but NOT Excel
  103. writing a function
  104. Solved: Defining .csv-file as workbook
  105. Range.find
  106. Solved: Coding a button to activate action
  107. concatenate in conditional formatting?
  108. Solved: Current Timestamp "Now" funtion format change
  109. Solved: Test for a string in a active workbook name
  110. Solved: How do I do this without inputing it in a cell?
  111. Solved: How can you trigger on when the sheet is printed?
  112. Trick Validation of combo boxes using VBA.
  113. How to avoid gosth userforms on screen
  114. Turning data with dates into a chart
  115. Solved: How to check if Excel is run from REMOTE server
  116. Solved: How to create multiple files depending on column values
  117. Solved: Listbox selection change
  118. Help on Count
  119. Excel's Visual Basic Editor Window
  120. Solved: Problems with an Error Handler
  121. Solved: [SOLVED] List Files & Cell Values With Specific Sheet Names From ListBox
  122. Setting Application.ActivePrinter and .PrintForm
  123. Solved: VBA Copy and Paste Help
  124. VBA Code to reduce file size of Workbook
  125. Presenting a Pdf File on a user form
  126. [SOLVED] Populate a textbox with the username
  127. Solved: Count help
  128. Solved: FORMATTING A CELL TO SHOW HR & MIN
  129. Solved: vlookup and copy data to spreadsheet
  130. Viewing a range of cells in Excel on a User Form
  131. Trouble with maximize and minimize button
  132. [SOLVED] VBA DataGrid User Form
  133. hy , excel for match stats and scors
  134. UK Excel User Conference
  135. VBA Dictionary Key Order Fixed?
  136. Solved: Calendar Control question
  137. # in VB
  138. Solved: excel range
  139. Solved: form load event not working
  140. Solved: Call Folder Picker from Cell
  141. Solved: Copy Option Button Caption to Cell
  142. Progress Bar Class Implementation
  143. Use multiple workbooks to one database with linking tables
  144. Solved: Shared network drive issue
  145. View worksheet as web page
  146. Solved: Input Box
  147. Need help with writing a program for importing data into Excel worksheet!
  148. Using ADO to connect multiple workbooks in a folder
  149. Solved: Better way to filter input?
  150. can a macro determine button that invoked it?
  151. Solved: Msgbox
  152. Using custom controls to call sub with argument
  153. Some Probably very basic VBA questions.
  154. Solved: Formula help needed
  155. Compare values in dedicated lists to values in pivottables.
  156. Excel Demds 120mb when starting
  157. [SOLVED] Delete Duplicate Row
  158. Solved: Help with excel-Macro to open file from http-link
  159. Assistance with Formula please (VLOOKUP/IF)
  160. Sorting data from userform checkboxes
  161. How to use SavePicture
  162. Solved: Customizing How Word Displays Information from Excel
  163. Solved: Capture System Time
  164. create a reference to a copied worksheet
  165. Command Button click
  166. Picture Formatting
  167. Dim
  168. Counting based on multiple criteria
  169. Solved: Charts using vba, works with Excel 2007 but error with previous versions.
  170. Urgent help Run tiME error
  171. Solved: Make a list of unique names from columns on multiple sheets
  172. Multiple Worksheet Onto Summary Worksheet
  173. Solved: On Error
  174. Refresh HTML file BEFORE importing to workbook
  175. Capture the Certain text in excel
  176. Help needed with Filtering a Drop Down List
  177. How can I list out all the properties, method do not exist in Excel 2007
  178. Creating Combo Type Menu Bar
  179. Solved: How can I copy sheet 1 from multiple spreadsheets to one new workbook?
  180. Solved: Email an excel sheet range using outlook.
  181. Solved: Duplicates 2
  182. Solved: CopyFromRecordset without formatting
  183. sort by 4 criteria
  184. Modify Code
  185. Sleeper: Locate and Open Outlook
  186. Solved: Preserving Values in Custom Functions
  187. Solved: Checkbox
  188. Solved: Excel data backup to MS Access
  189. Solved: Do While
  190. eliminating dups on excel mailing list
  191. Solved: Conditional Formatting
  192. Solved: Copy from Datasheetview to clipboard
  193. Solved: A quite complex relation search macro (hard)
  194. Solved: Formatting Negative Numbers
  195. Solved: Adjust Screen Resolution
  196. Solved: Identify the Macro That Called Another Macro
  197. Solved: alert message
  198. Solved: can you make command buttons look nice in excel?
  199. Let user choose chart type
  200. Solved: CreateObject("Excel.Application") Problem
  201. Consolidating multiple work books in multiple folders to one worksheet
  202. Solved: Count a different cells depending on what colout the font is???
  203. Last Populated Row in Range
  204. Solved: Moving from one worksheet to another based on a cell value
  205. Complex task in Pivot Table
  206. Solved: Text box
  207. Solved: Excel - Variable Lookup
  208. Solved: change sheet
  209. auto fill button
  210. How to include a dash in my search - VBA?
  211. Solved: Using the RefEdit Control on a Userform
  212. Move row to different sheet on excel workbook based on a cell entry
  213. Solved: Excel ADODB worksheet
  214. Solved: Unprotect a worksheet
  215. Solved: DCOUNT Excel Funtion
  216. Paste as Value
  217. Chart code problem
  218. Column selection, inserting column, multiple workbook users
  219. Replacing data within one Sheet only
  220. macro for protecting cell value from deleting
  221. Solved: Breaking vbNewLine - Breaks - Too Many Continuous Lines
  222. Solved: Searh and edit record from listbox
  223. Solved: Allow workbook interaction while Form visible.
  224. Solved: Need help with a simple loop.
  225. Solved: Need help with adding Next year's month
  226. Solved: Error Handling Question
  227. help to eliminate repeated inputs
  228. Need code added to a button to list some numbers
  229. Solved: Calling code from multiple documents
  230. Solved: Macro Help
  231. PDF to Excel/CSV
  232. Frustrating
  233. Solved: Multiple users in excel 2007 enterprise
  234. SOLVED: Open a workbook and copy data into another
  235. evaluate multiple conditions
  236. How Can I?
  237. Import from Outlook Express
  238. Am I using .Find correctly?
  239. Solved: Problem with update sheet data via userform
  240. Solved: Add a timer to Macro
  241. Performance Improvement Tips Needed
  242. SOLVED: Dynamic Printing Range
  243. edit notepad
  244. Solved: Flashing command button
  245. Solved: creating files from dynamic sheet names
  246. find value and delete next row
  247. Excel Userform - Dynamic Controls - Type Mismatch?
  248. show ComboBox at target in sharedworkbook
  249. Solved: WS Name function
  250. Solved: How to get the filter criteria automatically in AutoFilter