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. Automation Help
  2. Placement of a method
  3. EXCEL COMPATIBILITY DRAMA
  4. countif forumla
  5. hide textbox
  6. Solved: Delete duplicated, tally to make report
  7. Invalid forward reference error
  8. Speeding up the processes
  9. Solved: input data to post in worksheet
  10. Solved: Two input variables at vlookup
  11. Problem with Code (Inserting New Row)
  12. List box from columns?
  13. Formula -
  14. Solved: any way to delete & refresh contents in a dropdownbox?
  15. Problem with .PasteSpecial (xlPasteValues)
  16. Excel procedure to run Access Query using ADO
  17. Help: How to make list value change with the source
  18. UnprotectGreenCells
  19. How to find the Last Used Row on Each Sheet
  20. Solved: Change Cell Colors By CF
  21. Adaptive Database/Table
  22. Sumif with multiple criteria?s from another worksheet
  23. Excel Hyperlink
  24. Highlight cells on combobox selection
  25. Solved: Excel data organization nightmare
  26. Challenging macro
  27. search data from other worksheet
  28. Forms/windows or whatever it's called
  29. Coloring of the tab of a worksheet
  30. Solved: Copy/paste from all worksheets, except sheet1
  31. Forcing .xls to open in 2007
  32. Backgrounf formatting in Text Control
  33. Solved: Formula - Runtime 1004 Error
  34. Paste Special Bitmap Excel VBA to Word
  35. excel formaula
  36. Solved: VBE column references
  37. Solved: VBA Combo Box Coding
  38. Option choices - how do I export results?
  39. Solved: Procedure Too large to complete message.
  40. Return named range with vba
  41. Solved: Hyperlink on menu button
  42. Can't get a result of formula
  43. Macro help..
  44. Sharing: What VBAx Is All About- Give It Up & Smile
  45. To Compare 2 Sets Of Data And Change The Values Accordingly
  46. Solved: Value Added Tax conversion problem
  47. Import Txt and Parse
  48. Solved: Expiration Date
  49. Stop User from Entering Formulas
  50. Cell contents become ###
  51. Self filling combo boxes
  52. how to get: Index function keep value?
  53. Find Range & Fill Down
  54. Leave out blank items in combobox
  55. problem with paste to active workbook
  56. Help: HOw many color is there in Excel
  57. insert pagebreak if chart is not fully displayed
  58. SECURING VBA CODE
  59. import worksheets from changing workbooks name
  60. code to tell excel which folders to look into.
  61. stop clock help needed!!!
  62. Linking Problem
  63. The "BEST" formula function in Excel:
  64. Scrollbars for a Frame?
  65. Check if workbook exists
  66. How to position a chart?
  67. Solved: Understanding VBA minutes
  68. Creating the user GUi forms the right way
  69. Getting to know what element of ComboBox has been selected
  70. Store Value of Last Row even after the procedure ends and Excel Closes?
  71. Listbox Count
  72. Solved: Pivot Table Formatting
  73. Help with deleteing row conataining #VALUE!
  74. Solved: Simple Floating Toolbar - enhancement
  75. Forms, textboxes & labels
  76. Excel and Notepad: how avoid additional inverted commas after copy and paste?
  77. Test if Current Dir is Read Only
  78. Values and formats of only visible sheets and ranges copied to a new book
  79. Calling UserForms: FormName.Show or Dim Object/Set New?
  80. pivot tables and
  81. Solved: referencing different cells for calculations
  82. Solved: For Each Loop through Worksheets Collection
  83. Solved: Passing & Returning array to/from Property Get and Let
  84. Solved: Range object Id property
  85. freeze pan
  86. adding image to vba loaded userform sourced in sheet
  87. Solved: DisplayFullScreen Question
  88. users access
  89. Save a copy solution
  90. Solved: How to tell if no value is selected in a listbox
  91. Solved: How do I force recalulation of custom function on Workbook_Open?
  92. How to show Form abobe selected cell?
  93. VBA to grab data from other .XLS file
  94. Creating a Pivot Table using VBA
  95. Solved: Adding Sheets By Day Order
  96. Named Range issue using file online
  97. MultiPage manipulation
  98. Solved: Putting String Array to cells directly
  99. Solved: How to add an Accelerator to a Caption?
  100. Code for a find sort and copy.
  101. Weird runtime errors
  102. Solved: Clear white space off each column of each sheet of a workbook
  103. Solved: DISPLAY "0" INSTEAD of #NUM!
  104. Solved: Multidimensional Array
  105. Presenting two datas in a graph
  106. Solved: Replace tilde character fails
  107. Centering Text in a Message Box
  108. Solved: Formula or vba required for most frequent text in an array.
  109. Solved: Non-Contiguous Reference Clear Contents
  110. Creating a graph from a selection
  111. formatting a label
  112. dropdown on a form
  113. Solved: Sorting a Range, Header info?
  114. Help: Worksheet_change event disable "undo"?
  115. Solved: For Each Loop Through Sheet Collection Getting Wrong Results
  116. Random Numbers via HTTP
  117. Help Adding a constant text to a numeric cell
  118. adding new items to a dropdown
  119. Collect Data via The Web
  120. Editable Worksheet_Change result
  121. Solved: DATA VALIDATION
  122. Setting the limits in y-dimension for a graph
  123. Solved: ? Better way to code
  124. Number of work hours between two dates
  125. Solved: Highlight Text in TexBox on UserForm Open
  126. Controls on sheet OTF
  127. Help: Excel object size unit
  128. copy paste
  129. Copy data from excel to another application
  130. Solved: Sorting on each sheet balks
  131. Solved: multi summation of columns
  132. Why does this Crash
  133. repeating/looping through code
  134. inputbox variable validation
  135. Solved: If Instr line of code assistance needed
  136. Solved: How to move a comment?
  137. Why can't i select things on non-active sheet?
  138. Solved: Populate listbox
  139. To a.Copy/b.Paste or to b.Value=a.Value
  140. Solved: import multiple text files from listbox
  141. Collect Data via the Web: redux
  142. Public variable doesn't reset
  143. populating lists
  144. How to clear a userform after completion
  145. Solved: any way to clear textboxes on a userform?
  146. Consolidating multipule workbooks
  147. Declaring a variable and assigning a value to it at once
  148. Compare and Print with VBA
  149. Solved: one source two targets, pick with dv
  150. Solved: Setting Array for Two Sheets- Almost there
  151. object question
  152. Solved: Replace Method using variables to find/replace
  153. Solved: Multiselect listbox
  154. Solved: Inserting Blank Row
  155. Solved: update inventory when receiving and shipping
  156. Solved: Code for buttons
  157. Solved: How to add image to chart series point
  158. VBE opens by itself
  159. Solved: Find last row, Array Worksheets via Function
  160. Solved: Schedule a macro
  161. Solved: addTextBox: how to find points from top/left of a specific cell?
  162. Solved: Reorganizing Data
  163. find last cell with formula
  164. Setting up a UserForm
  165. Solved: How to Force a Formula to Calculate
  166. Alternating row colors while sorting???
  167. Solved: if value less then 5 show warning in worksheet change
  168. Difference between Sheet and Worksheet
  169. What object is missin here (error 424)
  170. Updating graph automatically once the data changes
  171. Solved: sum visible rows only
  172. Solved: Rolling average
  173. Solved: Building add-in errors
  174. get letter of the active column
  175. Opening workbooks via shortcuts
  176. Solved: Layout of Monthly Data needs to change
  177. Solved: Setting up a global dictionary
  178. hiding/unhiding a page on a userform
  179. Lock record creation in Excel
  180. Solved: Export data to .txt file
  181. Listbox Multi column error
  182. Different ways of copying
  183. Solved: End For Next routine on error
  184. Forumla Problem
  185. Method 'Range' of Object_ Worksheet' failed
  186. Solved: Extended 'ControlTiptext' for combobox items
  187. Structure of the array that is returned by ClipboardFormats
  188. Copying from one sheet to another
  189. check if Access file is open and who the userID is
  190. Solved: Sort list Box
  191. Lock active cell based on value in above cell
  192. Solved: Place Mult Select Listbox selections in specified cells
  193. "FIXED OBJECT WILL MOVE" ERROR IN EXCEL
  194. Solved: Syntax question: Range(....)
  195. btn click userform add row
  196. Solved: Getting Hyperlink from cell
  197. Solved: Method to instruct how many times to do something?
  198. Solved: Weird workbook on open
  199. column question
  200. flashing label
  201. Setting values for x-axis
  202. Solved: Connect Combobox to Named Range
  203. Problem with Excel 2003 XLA (Menu) Add-In
  204. Listbox problem
  205. Solved: WorksheetFunction.Vlookup Different Workbook Reference
  206. Cell swapping
  207. "Out of memory"
  208. HTTP: Yahoo Currency Conversion
  209. Solved: tooltip
  210. add a numerated worksheet
  211. Copy and paste macro different worksheets
  212. must activate sheet before paste?
  213. advanced graphs - plotting
  214. Edit Button images
  215. Solved: Copy multiple Excel Sheets
  216. Form not working, Cracking me up!
  217. Using sound in excel 2007
  218. loading all add-ins at one stroke
  219. Import Text File to tab in sheet
  220. Solved: 'Custom' data validation
  221. Solved: Print Multiple Worksheets Error
  222. Listbox columns from 2 sheets
  223. Click on a cell, which one was it?
  224. date of last backup
  225. Solved: Temporarily Remove Conditional Formatting
  226. Solved: Passing row height properties to array
  227. Pasting some tables form Excel in Word
  228. Can I use if, sum, match and offset functions to do this??
  229. Solved: ScreenUpdating Issue?
  230. Countif multiple criteria
  231. Solved: Getting Data From a Closed Workbook
  232. Solved: Writing to specific sheets on specific cells
  233. Solved: CHANGE FROM ALL UPPER CASE
  234. Workbooks.Open Does not Error if Workbook is not Present
  235. forms-comboboxes & textboxes
  236. Still a challenge
  237. increase numbers by percent in a specific column
  238. MultiPage -how to change Page color?
  239. Solved: Sum Across unknown Number of Worksheets
  240. I don?t want the hide cell to be copying!! How to do it?
  241. Hide "track changes" option
  242. I need a menu bar in a userform
  243. Seek help for value
  244. Solved: Read string variable while ignoring case sensitiveity
  245. Solved: Debugging Immediate Window Question
  246. IF-Then-Else in VBA help needed
  247. copy sheets and files
  248. Solved: Find "/" in string & debug.print ?
  249. Userform Save with contents of TextBoxes
  250. Closing Excel..