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 174

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