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

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