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

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