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. Prevent Calculation Running While Saving
  2. Call MS Access function in module via Excel
  3. Changing the font in the fluent ribbon
  4. File download without knowing the full url / redirect
  5. Solved: sum only certain columns
  6. Last Updated Alert
  7. Solved: Making a Range non-editable
  8. Sleeper: Disabling of cutcopypaste for a few cells in a worksheet
  9. Solved: Finding Min & Max values by week, month and year
  10. Automatically insert rows at varied intervals
  11. Add different password(S) to worksheet(s) from workbook
  12. Solved: Saving File - Automated File Naming
  13. [SOLVED:] Date Formatting help
  14. Amend VBA Code to include extra worksheet(s)
  15. Solved: Count cells with 3 requirements
  16. Solved: Counting number of times a code has been executed
  17. Import mutiple files from a folder to excel files
  18. Solved: Hi-Lite a cell based on value in another cell
  19. Copy formula down the column
  20. Solved: Excel to Outlook - late binding?
  21. Solved: Data Export
  22. Solved: countif with multiple criteria
  23. Solved: Min of 4 Nos,returning >0 values
  24. Automatically Generate Reports from Excel Template
  25. Solved: If statement - Cell starts with Number
  26. Solved: hyperlink question
  27. Solved: Formatting cells with times
  28. Solved: How to get AVERAGE of range into a cell
  29. Solved: How to export an excel chart as a jpeg
  30. Solved: Search for text as part of a cell
  31. How can I create an Object and send by email?
  32. Merge & compare excel formula
  33. [SLEEPER:] VBA multiple ranges
  34. Solved: Values to Text
  35. Solved: Send button value as arguement to macro
  36. Search for repeated characters
  37. Passing Parameter to Excel for SQL Report
  38. need to automate date of last data entry
  39. Form Close help
  40. Solved: Pulling Data from several sheets to one - Macro
  41. Solved: Format cell when condition fulfilled
  42. Solved: conditional population of cell
  43. Solved: How do I identify the type of graphic object that is currently selected?
  44. Excel save file
  45. Solved: Read only password
  46. Multiple copies of Active Worksheet
  47. VBA Find from EXCEL replace to WORDS HELP !!!!
  48. How to call sub(which is personal.xls) in activeworksheet.
  49. convert to pdf to excel using vba
  50. Solved: copy and paste macro - simple, right?
  51. Selecting Column Until End of Another Array
  52. Can complete VBA code be exported to a different WKBK
  53. How do I preserve the user's Clipboard while he's accessing my form?
  54. Running Macro on Muliple Files
  55. Solved: Match help
  56. Limit data field in PIVOT TABLE
  57. How to detect a digital certificate
  58. VB copy & paste help .......pleased
  59. Copy Paste Values
  60. Solved: IF THEN COMMAND
  61. Using two Userforms.
  62. Solved: Help for FY problem
  63. Solved: Importing space delimited text files
  64. Solved: Sending Long to Clipboard or any other way to get it to Word from Excel?
  65. Solved: maximum function with #na value
  66. [SOLVED:] Ranking Data in List
  67. Solved: Check my code please to find next blank row
  68. SaveAs with embedded Word document - OLEObjects
  69. Solved: Conditional Format to a Linked Cell
  70. Using Excel to look at charts
  71. How to convert dates in my Sub
  72. Solved: Setting a Range as a Class Property
  73. Copy and paste count by last row
  74. Critical Thinking Challenge
  75. Solved: Test if rows are hidden
  76. Solved: How do you modules to calculate?
  77. My Excel Crashes on Close
  78. Solved: Outlook Email Blast from Excel
  79. Solved: Calculate "Current Month Average"
  80. Inserting Carriage returns in Message Boxes
  81. Solved: SUMPRODUCT across multiple sheets
  82. Solved: Set Value of Merged And Centered Cells
  83. Solved: Reference another Excel workbook without Activating it
  84. Solved: calculate percentages using sumproduct?
  85. [SLEEPER:] Merge / Combine Multiple workbooks
  86. Using Excel 07 for complex web queries?
  87. Userform Spinbutton to advance row and refresh
  88. Paste the content from Excel to UserForm -> TextBox
  89. Solved: Function Required for Mega Formula
  90. copy contents of csv files
  91. Solved: Filter by Date Selection?
  92. Aligning a chart to cells code
  93. Solved: Parsing a field
  94. Solved: Point And Figure Chart
  95. Solved: validate Combo boxes
  96. Solved: Max Value and the date it occurred?
  97. Using name ranges with sumproduct?
  98. FTP an Excel File
  99. Hide Checkboxes based on last column
  100. Changing named range in loop
  101. Solved: Max Values - Formula solution
  102. need help in excel sort
  103. tracking changes
  104. Fill down formula with data pivot change
  105. Solved: import and split a text file into worksheets by year
  106. Problems creating large numbers of sheets
  107. How to format cells in one row
  108. Solved: Using Comments to Document Formula
  109. How to avoid displaying a warning box on save?
  110. Solved: Filtering Columns
  111. Solved: Complete excel sheet on command
  112. Filter the specific data and find the difference
  113. Sequence two or more loops - VBA code
  114. Check Version & Download Latest
  115. macro to perform selective addition
  116. MULTIPLE CONDITIONAL FORMAT WITH FORMULA IN PIVOT TABLE
  117. How to exit print preview mode?
  118. Solved: Charts automation using vba, works with Excel 2007 but error with 2003.
  119. populate list/combobox without duplicates
  120. Get email address of the user log from excel vba
  121. How to add only 1 worksheet from an Add-in
  122. Merging two sheets
  123. Solved: Workbook Save Flag
  124. Can i use arrays here?
  125. Solved: getting values from files with changing names
  126. Solved: Problem in append data to next column
  127. [SOLVED:] Last Saved Information
  128. Solved: clear clipboard before closing excel
  129. How to create in excel a form with a menu?
  130. Modify Variables in One Workbook from another Workbook?
  131. [SOLVED:] Copy/Move Worksheet
  132. [SOLVED:] Unmerge cells & Auto-fills
  133. save function not working properly
  134. Right Click Menu of Sheet tab
  135. inserting rows
  136. Problem pasting a Picture into an image control
  137. File Access
  138. Formulas to measuer four two criterias
  139. Solved: Fill the blank cell
  140. Can't name a command button with code
  141. Solved: Delete sheet greyed out
  142. cell reference from one sheet to another
  143. Vb Error Prompt
  144. [SOLVED:] Worksheet Function Compile Error
  145. Solved: Advanced Filter with empty cells
  146. ZIP the files using VBA
  147. Select last active cell, offset (-50, 0) copy
  148. VBA Error Subscript Out of Range
  149. VBA combo-box printing pdfs
  150. Forget Password
  151. [SOLVED:] Solved: Help with random sampling code
  152. How to inser Row using VB
  153. How to remove protection password using Macro
  154. Solved: Where did the 07 known issues thrd go?
  155. Select Unique values from a coulmn
  156. Solved: Custom toolbar for use in all instances of Excel
  157. Custom data transfer based on criteria
  158. Solved: Excel VBA Groupwise (File names)
  159. how to add columns from other excel files
  160. Solved: Summing tasks for a Month period
  161. update master worksheet from multiple workbooks
  162. Solved: Multiple option buttons on user form
  163. Solved: Populate Combobox with spreadsheet col
  164. Solved: Prevent users from entering "Essential Position" in more than one worksheet
  165. Solved: VBA to hide unrequired sheets?
  166. Synchrinizing excel file
  167. Solved: Special Cells - Count
  168. Solved: Calling a sub procedure using variables from another sub procedure
  169. Loop Conditional Statement through 2 columns and Copy/Paste from corresponding column
  170. Solved: Find Replace Macro for Selection
  171. countdown timer
  172. Macro for refresh
  173. [SLEEPER:] My macro stops half way through because of a dialog box
  174. Reading .txt Files
  175. [SOLVED:] How to see when was a workbook last time opened
  176. save as csv file codepage problem
  177. Button loses connection to macro when I "Save As".
  178. Solved: function to calculate average
  179. Dynamic Sheets
  180. If statement for Cells.Find
  181. Solved: Update worksheet data through userform
  182. Solved: move data in Excel
  183. Calculating Days and Inactivating the columns
  184. [SOLVED:] Vlookup Sum help
  185. [SOLVED:] Countname function
  186. Solved: calculating a %, based on the bg color of a cell
  187. txt list function excluding zero
  188. Display special values in Column B
  189. VBA userforms, control is command button is visible
  190. Pasting a worksheet to another worsheet in another workbook
  191. Capturing headings of frequent data
  192. Can you use variable to change caption on command button
  193. Irregular do loops
  194. Displaying data from worksheet range in listbox
  195. Solved: VBA saving macro
  196. Solved: Insert Rows basis value in Cell
  197. Solved: WITH statement must be inside Do...Loop?
  198. S: Graph Whole Row but automatically omit columns with no data and do not graph these
  199. random columns to be copied
  200. Solved: For Statement Inside Select Statement
  201. Solved: Help to imrove the coding
  202. Solved: Copy entire row to new worksheet on found cell
  203. [SLEEPER:] How to do multiple vlookups?
  204. VBA to Set a sheetname as a Variable and call from another workBook
  205. Only allow one input at any given time
  206. Solved: How to hide Formulas
  207. Help with storing varaible value to use later
  208. Solved: Split 1 Cell into 2 cells
  209. Solved: switching between yes and no using data validation
  210. Quickly Delete or Hide Rows if Column N is blank
  211. 2 sheets, matching many:1 date fields, copy value if true
  212. Using Countif in VBA
  213. Solved: Fill an Array based on Range Values
  214. Solved: Lost Focus
  215. [SOLVED:] Remove Excel Userform Using VBA
  216. filtering data from two or more sheets
  217. Solved: Two Vlookup's in one cell
  218. Find & Replace VBA help
  219. Recovering conditional Formatting after running Macro
  220. Solved: Copy row with condition thru userform
  221. click link in web page
  222. I want to send a pic as an email attachment
  223. Paste Picture based on cell value
  224. Solved: Creating Dynamic Named Range
  225. Error: 'Cannot find project or library'. 2002/200 compatibility error?
  226. Solved: Create Validation List In Next Cell
  227. [SOLVED:] Error Handler: Pass the Calling Macro Info
  228. Solved: Don't allow user to delete formula in Validation
  229. Copy columns based on cell value
  230. Solved: Auto Numbering Requirement
  231. Determining if a date meets a criteria
  232. [SLEEPER:] Paste to unused field
  233. Solved: Array help?
  234. Get values from excel in other machine
  235. Solved: Is this a Vlookup problem?
  236. Solved: Copy fixed 3 cells from multiple files with 1 or 2 or 3 sheets
  237. Solved: Save only if path is true
  238. Find and Delete Multiple Rows based on Criteria
  239. macro help
  240. multiple questions about listboxes
  241. Solved: Possible Vlookup or Index/Match formula help
  242. Using list of locations, open excel files, extract data to new spreasheeet
  243. I'm a beginner, and even this program is driving me crazy
  244. Excel Macro help
  245. Can I delete a control from a running form with code?
  246. [SOLVED:] Macro to remove headers in a multiple sheet spreadsheet
  247. If statement to run a module
  248. SEND EMAIL DUE DATES WITH FORMULAS IN SPREADSHEET
  249. XMLHTTP connection timeout
  250. VBA - Find, Copy then Paste Special