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

  1. Solved: Looping: Copy two worksheets to new workbook
  2. Solved: MsgBox if birthdate is <1 year ago?
  3. VBA - Need Help for a SQL Query
  4. Solved: VBA - form/workbook problem
  5. Keyboard shortcuts
  6. Hyperlink Problem when print Excel to PDF
  7. Solved: Macro need to direct a cell value to the corresponding named worksheet.
  8. Solved: Adding 2 worksheets to an existing workbook
  9. Nested Collections
  10. Macro to copy paste data
  11. Solved: Iserror in VBA setup
  12. Inventory control
  13. Solved: Need Help with the Logic of my Program
  14. AutoCorrelation and Partial AutoCorrelation series Generation
  15. Load Excel Userform from Powerpoint Button
  16. Solved: Sorting a column alphabetically, however a blank row between names must be retained.
  17. Continual Import of Excel data into Sharepoint list
  18. Solved: Webbrowser page depending on listbox value
  19. Solved: how to reference previous cell value
  20. Need Help developing an Algorithm to Decode MathML (XML)
  21. Delete the duplicate value/cell in selected range
  22. Excel VBA recognizing the variable as Date wrong
  23. How to exclude hidden pivot field items in count
  24. Copying data from DB in a Sheet
  25. Change Array Arguments to read horizontal instead of vertical
  26. Count of rows excluding a set of values in the another sheet
  27. Solved: Conditional Formatting a worksheet based on value in a cell in another worksheet
  28. Excel Formula Help
  29. Pivot Chart and Table Problem
  30. Solved: Copy string to clipboard in VBA
  31. Sorting Collections
  32. Solved: Deleteing unused word bookmarks
  33. VBA to open Excel & Enable Macro
  34. Solved: User Form syntax
  35. Loop fifty files into one file
  36. Code to Filter, Copy, Paste and Save Data
  37. Excel Vba for Macros...
  38. Solved: sumproduct formula error
  39. Solved: IF Formula problems
  40. Solved: Excel VBA Open / Save As
  41. Solved: Copy selected cells in all worksheets and paste into another worksheet
  42. Solved: Deleting data within a named range (xl '97)
  43. Macros help
  44. Query-Style Custom Function needs speed boost!
  45. Strange combobox problem
  46. Solved: Assign Macro to Runtime-Generated Textbox Event
  47. Sorting then send
  48. Solved: How to open all files in folder using input box
  49. Solved: MS Excel: Password Problem
  50. Solved: Limit input to textbox
  51. Using FieldInfo with variable array content
  52. Solved: Explanation of Advanced Filter
  53. Selecting more than cell VBA
  54. Vlookup
  55. Solved: VBA code to periodically copy data
  56. Buttons to Start and Stop Macro
  57. Dynamic graph
  58. Solved: clear cells without form appearing
  59. Solved: Create a marco that will autofill a formula but the range is variable
  60. filter - hide active cell content
  61. Solved: Make chart where source data range is variable
  62. Chart Colouring Macros
  63. Solved: Find is not matching expected values
  64. Solved: Loop through user specified folder
  65. Solved: VBA lookup to insert value into cell.
  66. Solved: Excel equivalent to MS Word's DOCVARIABLE?
  67. Why do create a temporary variable and then set the value to a function?
  68. Solved: add to existing value by matching
  69. Vlookup the price in latest date
  70. Truncating cell data to fit in cell
  71. Solved: Custom Prompt box w/ multiple buttons
  72. Solved: Low inventory alert
  73. Solved: Invintory Project.
  74. Solved: Add opened file into a summary workbook
  75. Solved: Reduce size of current region
  76. Print PDF file
  77. Solved: When replacing a sheet, how to fix refs?
  78. Clearing and resetting CTRL+END
  79. Displaying text with freeze panes
  80. Chart source data depends on the sheets choosen on the Combo box
  81. Solved: Prompt comment?
  82. Solved: Change caption of a button on spreadsheet without selecting it
  83. Incremental Change in Values of Data Table
  84. Solved: Auto-repeating input error
  85. convert Exif photo data to excel
  86. ActiveSheet.Paste Error
  87. VBA to disable close
  88. VBA Compare Excel Files Macro
  89. Solved: Script to add values in new sheet without blank rows
  90. Solved: use GetOpenFilename with only few files displayed
  91. Solved: Find value and count occurances of text
  92. Solved: RANK (??)
  93. Recording web application using a macro?
  94. Solved: Find Empty Column Range
  95. Write to Output File w/out Overwriting Everytime?
  96. Solved: Add to comment?
  97. Solved: Automatic addition of comments to entire column
  98. Solved: Finding complicated average
  99. Advanced Find & Replace
  100. Solved: input box loop
  101. access invoice to excel combo box vba urgently need help
  102. Solved: extract values in a range
  103. Enum replacement for saving double datatype
  104. Macro to copy formulas across a worksheet
  105. insert image
  106. Date variables
  107. Using embedded pics
  108. Check if Column Exist & it in sequance
  109. VBA and XML::Conversion of Sorts
  110. Solved: open Excel filename with only certain characters
  111. Solved: Incorrect Date Brings Up MsgBox
  112. list names of all saved files
  113. Solved: Clear corresponding cells when changing one cell in a row
  114. Solved: Variables in message box
  115. Solved: Increase value of a Cell by 1
  116. Solved: password policy when opening an excel sheet
  117. Solved: cannot select multiple cells at a time
  118. Call Sub when cell is double clicked
  119. Solved: Comparing Cells
  120. Solved: Sub to Go Back to Stored Range
  121. Solved: Summing of Totals
  122. Solved: Why doesn't this work?
  123. Solved: Partial file name
  124. Solved: Goto previous cell
  125. Solved: Clear shapes BUT save buttons
  126. auto serial number
  127. Solved: Disable subs depending on which button is pressed
  128. Solved: Format Date + 3 months
  129. Solved: Hyperlink activation of Script/Macro
  130. Solved: How to rename a worksheet if name already exists
  131. Cell References
  132. Workbook size
  133. Solved: Shapes & Values
  134. Auto increment number & Date Stamp
  135. Script to show up time zone in excel
  136. Syntax error
  137. Search list, find value and return binary value.
  138. Solved: VBA file names (and more) from folder on worksheet
  139. Problem with Contour Graphs
  140. Macro from Number to Letter
  141. VBA to download data from website
  142. Solved: Hyperlinks warning
  143. Arrange the values as per pre-defined orders
  144. Help with search form
  145. Capture user data
  146. Iterating through a list of cells
  147. VBA sorting method
  148. Solved: How to Recognize this string properly?
  149. Solved: Lottery Checker
  150. Solved: Activate vba in another workbook
  151. Arraylist or something else help
  152. Solved: Lookup Value, Copy and Paste Row Values?!
  153. Type Mismatch error
  154. Shapes and values the sequel
  155. Solved: Checking to see if a cell contains a Number or Letter
  156. Problem with range selection
  157. Message box with options
  158. Solved: Close Excel Command Button
  159. Can Someone help with this For Loop?
  160. Solved: opening email with selected names and attachments
  161. How to get subtotal ignore subtotal which is netted in If()
  162. Solved: Is there a Function in Excel to Determine the Row Length?
  163. Solved: What am I doing Wrong in this simple Code?
  164. IE login and logout from Excel
  165. Solved: Type MisMatch!!
  166. Solved: date & time difference
  167. Solved: unprotect sections of word document with excel
  168. Solved: copy late items to new sheet
  169. Solved: I am the Worst:: Something is Terribly Wrong w/ My Code
  170. How to populate missing digits in a date cell or convert US to UK date format
  171. Need help for "Format" function
  172. Code update with the help of form
  173. Solved: Userform Pop-up when opening excel
  174. Solved: VBA Graph - Tweaks Needed to Amend Font and Placement?!! HELP!
  175. Quick Question ABout Setting a Range
  176. Solved: Case statement
  177. Solved: Problem With .pagesetup.printarea
  178. Progress Bar
  179. What am i Doing wrong
  180. Solved: The Trouble with For-Loops
  181. Warning message open file
  182. Solved: Number Based on Date
  183. Solved: ADO handling
  184. VBA CODE OLAP Pivot Table Excel 2007
  185. Solved: Date and Time Difference 2
  186. Solved: Data Validation Negitive
  187. Amend HTML file
  188. Solved: If 8th character ...then
  189. Solved: UF textbox 8th character
  190. Solved: Hyperlinks to Hidden Worksheets
  191. script to pull email information onto excel
  192. adding time 15min in a textbox
  193. If statement help
  194. how to set a value to an external cell ?
  195. create a list of numbers in a single cell
  196. Solved: Hide Row based on particular word
  197. code without select
  198. Solved: MS SQL OLEDB struggling
  199. Solved: Stored procedure w/ w/out parameters
  200. Need Assistance with Text Font Color Change
  201. hide columns depend on cell values
  202. Solved: Data population based on a field entry
  203. Solved: Using an If statement on change event procedure
  204. Solved: copy visible cells
  205. printing pdf's i open thru excel vba
  206. Checkbox problem
  207. Solved: Infernal 4s
  208. Solved: Combo Chart creation
  209. Solved: Populate userform from selection of another userform
  210. Excel variable for path
  211. Need help with a multiple if statement on a change event procedure
  212. Emailing from Excel
  213. Solved: Forumla with defined sheet name in other cell
  214. Process all values in search area to retrieve all matches
  215. How to implement this effectively
  216. Solved: Using named range to plot chart data
  217. Solved: Compiler Directives (#Const, #If, etc.)
  218. Update links with all files closed
  219. [SOLVED] Run-time error '-2147417848 (80010108)'
  220. How to load hyperlinks in userform listview
  221. Need help for Dynamic Data
  222. Solved: Reformatting a WorkSheet
  223. Solved: Find cell containing PART of string
  224. Something "Off" About my Code ??
  225. Balance two elements to a number
  226. Problem with Nested IF function
  227. Need formula to get that output
  228. Format textbox to numbers in Userform
  229. Solved: Formatting bookmarks
  230. Manipulate a string
  231. Solved: Deleteing Word Chart Rows if all cells are empty
  232. Stop FIND() errors - related to my late post
  233. Solved: Case Select
  234. Pivot table macro
  235. adding cell in excel vba
  236. Check if selections in listbox are contiguous
  237. Solved: Compare dates
  238. Consolidate Data from Mutiple Sheets in Summary
  239. How to check if file is open
  240. Solved: Calling Subs::Error "Compile Error: Expected Variable or Procedure, Not Module"
  241. Solved: select txtbox
  242. Solved: Cell Format being Weird
  243. Solved: match and return offset value in cell
  244. how do i sum a total of multiple numbers
  245. array in vba
  246. Insert/Delete Rows on 2 sheets simultaneously
  247. Solved: randomize rows in range
  248. Macro on Server
  249. Convert text to numbers
  250. Solved: Conditional Formating with multiple If statements and conditions