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