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

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