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: Count cells except empty cells
  2. Help using VBA
  3. Referring to the first and last cell of a range
  4. Solved: Cut and Paste Problem
  5. Excel VBA error method 'minimumscaleisauto' of object 'axes' failed
  6. How to search and modify existing record
  7. Solved: Code runs on other open workbooks
  8. Solved: Calendar Form pass control back to UserForm
  9. Conditional format
  10. right click copy
  11. received time to excel
  12. Program cells and allow manual input
  13. applying formula on active cells
  14. Solved: Limit input characters in a cell
  15. Investigating a more object orientated approach to doing formulas, need help
  16. Code to Group Worksheets on Open
  17. Excel 2007 After Password Entry Not Changing Permissions
  18. Web Query to grab zip codes from USPS
  19. Solved: Formula to use for picking out the first of a common reference.
  20. How to replace word character to excel character
  21. Conditional formatting again
  22. Writing Vlookup w/ dynamic 'table_array' in syntax
  23. VBA report formatting
  24. Copy to a specific cell
  25. limit records in import/linked data
  26. Solved: Delete rows if part of string is not xls, doc, txt or csv
  27. Protection
  28. Filter By Listbox Criteria
  29. Filtering out unique items and summing up values only once
  30. Solved: delete some columns and add borders using macro
  31. Solved: Password Protect Excel 2007 Workbook
  32. Number To Letter
  33. Solved: Formula help
  34. How to read the contents of an OLEObject (dropdown list) in excel
  35. "Excel 2002 Search Macro Help"
  36. SMTP emailing
  37. Solved: limit scroll area in all version of Excel
  38. Solved: Multipage versus multiple forms in Excle
  39. Solved: Calendar in Userform
  40. Weird problem: Quick Access Toolbar with scripts can't be saved on local hard drive
  41. Solved: Transpose data from one sheet to another
  42. Solved: Excel on double click event help
  43. Go To Sheet
  44. Please password protect my file
  45. default dropdown by region?
  46. Excel to Outlook
  47. Comparing 2 Columns
  48. Older posts
  49. Solved: Sequential unique numbering in excel
  50. Read xml File into Recordset
  51. Copy Chart from Excel to Powerpoint
  52. Replace Dates with Text in a formula
  53. Printing Unique Records
  54. The Control Named X does not support saving?
  55. Deleting Blank Rows
  56. Help on #N/A error
  57. Solved: Copy This Formula Down Rows
  58. Why does VBA slow down on this?
  59. Solved: Combobox Highlight Causing Readability Problems
  60. SUMIF with two conditions
  61. regarding IF commands into VBA
  62. Solved: Fast Cut and Paste
  63. sum the numbers under criteria
  64. How to Display Embed Objects in Sheet?
  65. Delete Specific Rows
  66. Compare 3 columns and delete the duplicates
  67. Problem after removing PDFCreator
  68. Solved: Is it possible for excel to execute a command like add files to a zip archive?
  69. how to use vba to automatically download a file
  70. How to change a date in one sheet and it add a value in another
  71. VLOOKUP question
  72. Import CSV using ADO - Missing negative values
  73. Solved: excel delete a workbook
  74. Solved: Listing all files in directory including zip files
  75. Changing line color of a graph with VBA
  76. Solved: Checking the value of a check box
  77. Use calendar to get value from selected date
  78. Commandbar ComboBox
  79. Font Color Index
  80. Lookup Help
  81. Solved: Using cmdbutton.caption in msgbox
  82. How to Use the Format Painter Selectively
  83. Exchanging argument values between macros in different wokbooks
  84. Toggle bold button
  85. Flag Rows Randomly after Applying Filter
  86. remove duplicates and transpose columns to rows
  87. Help with VBA code for single selection listbox
  88. Hide/Unhide sheet based on cell value
  89. Change name of VBA Created button
  90. VBA Run a Macro while staying on the same sheet
  91. Moving Cells within a spreadsheet
  92. Update Macro
  93. Create a Const that references a Range
  94. With Statement
  95. Solved: Required Cells Before User Can Save activated by a trigger
  96. Solved: Restrict specific words from a column
  97. Solved: Lotus Notes to Excel (If, your looking for a Challenge)
  98. search and copy to another sheet
  99. removing duplicates from table in memory
  100. Solved: Help - Select Case ActiveControl.Name
  101. Format cells
  102. problem running vba in excel
  103. copy and search
  104. help with vba calculation on several columns based on row.
  105. Solved: Help required on Filtering a Pivot Table
  106. Solved: Copy Module
  107. making calculation on named range col but returning col number total
  108. Solved: Date formula
  109. Fixing postal addresses
  110. Increment in date value if time exceeds a particular value
  111. STOPWATCH
  112. Formula help
  113. UpdateLinksNever when Adding Template
  114. Excel 2002 Find and copy to another worksheet"
  115. Conditional Formatting for Constantly Changing Spreadsheet
  116. Solved: sort activeworksheet, out of range
  117. Making a chart's x axis dynamic
  118. Solved: paste file name in all rows of a column
  119. Link to another workbook and find duplicate entries
  120. Autofilter with VBA
  121. Command Button to send SS as E-Mail
  122. Search entire column for word/phrase and list results
  123. Solved: VBA to find last populated cell but ignore formulas returning blank
  124. VBA PLOT JUMP ROW
  125. Solved: VBA inserts spaces into formula
  126. Open, find and replace in notepad++ using VBA script
  127. Count Formula
  128. Create Macro - Select Range?
  129. Vba help
  130. Loop link to spreadsheet.
  131. message box format
  132. loop help
  133. simulating keystrokes
  134. Excel Spreadsheet to Word UserForm
  135. using VBA instead of fomula in the sheet due to multiplie calculation
  136. Worksheet function Sum in Excel VBA
  137. multiply names in variable (userform)
  138. Activating Hyperlinks
  139. Solved: vba delete entire row
  140. Face IDs and Buttons
  141. How to add rows to tables using macros
  142. [VBA - UserForms] Adding
  143. overflow runtime error
  144. Solved: check box logic
  145. Filter rows on sheet 2 when a certain option is chosen on sheet 1
  146. File is not a recognizable format
  147. Solved: Menu?
  148. Events
  149. Extending COUPNCD for monthly payments
  150. Excel Password Recovery
  151. Rename Worksheet Tab in UPPER CASE
  152. Change formulas to values, but with some exceptions
  153. Solved: Save file with worksheet name
  154. Macro to Select Range and Copy
  155. populate comboboxes multicolumns ignoring empty filds
  156. i have a problem about fields of executed query in vba
  157. vlookup or something else
  158. Copying Down Formula using VBA
  159. Logo Place Holder
  160. Solved: Identify Unique Cells In Range
  161. Solved: Remove Duplicates
  162. Solved: Cleaning up a list.... direction please.
  163. VALUE = NOTHING
  164. Solved: Possible for excel to detect inactivity at pc?
  165. Solved: trigger msgbox once
  166. Toolbar macro won't run
  167. Scrolling down a list to find a specific number
  168. global arrays are reset after pasting images from another sheet
  169. getting file path of image
  170. Solved: delete part of string in every string
  171. Solved: convert formula to VBA
  172. Solved: delete content after save
  173. Entering data in next empty row
  174. Solved: Excel VBA - Save As with Password
  175. Recognizing Time > 24h
  176. Excel VBA Help
  177. click save csv files
  178. extracting phone & fax #
  179. Solved: Date stamp in column L if forumlua in column W = 1
  180. dynamic graphs
  181. Solved: VBA to Hide Toolbar
  182. Solved: upload file
  183. Solved: combine multiple workbook become one
  184. show me the way to the next ...
  185. delete workbook after a certin time period
  186. Solved: Have code check for 2 sheet names and copy values from them
  187. Excel attachment with lotus notes
  188. Solved: Compare columns in different excel files
  189. How to close FORM in ANOTHER WORKBOOK
  190. Question about CountA() and dynamic named ranges
  191. Solved: Formula help again
  192. Hide/Unhide rows - NT login
  193. Solved: Exit and Exit Full Screen
  194. Solved: How to do repeated File-Open commands in alternate locations
  195. Solved: Sort Defined Range
  196. Can I use IF function and run a macro?
  197. Refreshing External Database Query In Excel using VBA
  198. Solved: Formula take 2
  199. Hiding, Copying and pasting in a specific order
  200. Remove Conditional Formatting
  201. Solved: How to Exlcude some charts from Macro
  202. Solved: KB Article
  203. Application.InpuBox restriction - input 1 cell
  204. Excel 2007 Clear Cache at run time?
  205. Solved: Counting Substring Presence in Range
  206. Automatic Select Based on Cell Value
  207. Solved: encounter error
  208. Linking Excel Cell with Text Box
  209. How to do Multiple If Statements Shortcut!
  210. Disable cut/copy/paste - but still be able to copy between workbooks??
  211. Pivot Table VBA
  212. Solved: Run Time Error '76'
  213. Solved: Copy files given location to a new location
  214. Solved: Save as 'todays date'
  215. IFS, ORS, ANDS???
  216. Solved: Issue with applying a name to a range in autofiltered table
  217. Controlling IE sub documents from Excel VBA
  218. Form Picture help
  219. date problem on a form
  220. autofilter problem
  221. setfocus on a form
  222. calculation col and rows min and max values
  223. Solved: Changing color of item in listbox based on value of specific cell
  224. Linking Password Protected Workbooks
  225. Solved: Hiding Columns if all cells = zero
  226. encrypted macros
  227. open a file based on a modified date
  228. Disable userform.show
  229. [SOLVED] Locked cells - values from macro
  230. APIs in VBA Help
  231. return specific values
  232. Solved: Setting a range to the result of a formula
  233. Accessing a Database through VBA
  234. opening new instance of Excel when opening file
  235. Solved: remove vba
  236. Array Help
  237. Tidy up of code required
  238. how to force paste-special values in excel
  239. Selecting typical Data and copying in a new sheet in other format
  240. Best Match
  241. Solved: finding if two controls overlap
  242. Solved: Combining two bits of vba
  243. Solved: conditional formatting VBA
  244. Hide Horizontal Scrollbar
  245. Find value and copy value from another column
  246. Solved: Create chart based on current month
  247. Conditional formatting for entire row for text based values using VBA code
  248. Compare two worksheets
  249. Load list of ftp files from directory into a userform?
  250. Solved: Update UNLOCKED cells on a different sheet?