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