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

  1. Solved: Compare 2 collums and have a message box display varience
  2. add a picture to comment
  3. User-defined type not defined
  4. Solved: MsgBox "Prompt Message"
  5. Windows task scheduler and Excel
  6. Solved: need to select and run macro on all worksheets in workbook consecutively
  7. GOTO A different Worksheet named in cell A1
  8. Solved: how to open a folder?
  9. Solved: Checkbox confirmation
  10. Help: How to get date input in specific syntax
  11. ComboBox help
  12. Hide Rows Based on Condition
  13. Solved: Keep Track of a Workbook Review
  14. Locking Form Controls
  15. Simple Comparison
  16. Solved: Filter list and place results below
  17. Solved: filesearch for .txt and text conversion
  18. Count number of times word occurs in selected column?
  19. Solved: Custom Menu and Toobar Items for a single file.
  20. adding/sizing images.
  21. Solved: RESOLVED - How do you set a max column range?
  22. Solved: Alert Message and highlight duplicate
  23. Solved: Build file string to import an HTML file
  24. Solved: Need to convert date to three letter month
  25. Solved: Split test column as string
  26. Inconsistent Behavior When Capturing Application Events From xla Add-in
  27. Data validation with dependent dropdowns from a sorted list - seperate document?
  28. Solved: How to reset only the current row color?
  29. Create a new worksheet from existing worksheets plus doing calculations.
  30. Solved: Extracted Sheets Limits to 43 only why?
  31. Solved: Formula in vba help
  32. Tracking blood sugar levels
  33. Class property vs public variable
  34. Solved: Range cell color by Double Clicking
  35. Solved: Problem delete and replace item
  36. HTML Data to Excel Cells...Help
  37. Can I Cascade Dependent Validations?
  38. Error running second time
  39. Solved: Split ONE word into TWO cells
  40. Solved: BeforeDoubleClick Question
  41. Solved: How do you prevent a row color change event?
  42. Solved: Timesheet Weekly Totals Help
  43. Solved: Is MS excel installation necessary to run VBA code?
  44. Solved: Insert lines after so many rows
  45. Closing Errors...
  46. Solved: Connect to Oracle
  47. Solved: userform to search datasheet & return values
  48. Solved: If make confusing..
  49. Solved: Printing an array of sheets
  50. Solved: Test if there is a Ranged Name already
  51. Solved: Extracting just the Number in a name
  52. Visual Basic - Import and Insert Photos
  53. Skip Cell VBA Help Change Code
  54. microsoft access barcode control 9.0 active X running error
  55. Solved: If Value in one column is something and another column is mandatory
  56. Renaming Defined Ranges
  57. How to load specific items to the listview 6.0
  58. Solved: OT - Help Needed To Access My Own Workbook
  59. Solved: Can this code be made any more efficient?
  60. Solved: Range Select problem
  61. Can not understand what it means!
  62. Create Copy of a Control
  63. Solved: Help improve reverse loop
  64. MSCOMM32.OCX ....Problem
  65. Solved: How to create a "Live" points table
  66. Solved: Merging sheets and stopping Excel from date formatting cells
  67. execute excel
  68. Solved: Floating Toolbars
  69. Progress Bar
  70. Solved: Finding ID Number & Using That Row
  71. Trigger a macro when result changes
  72. How to protect my project
  73. Solved: Log In-Out Sheet
  74. Worksheet DoubleClick Event
  75. Solved: How do you run ThisWorkbook code from a module?
  76. Solved: Sheet tab change event
  77. Filter ListBox based on a ComboBox
  78. Form not changing transparency
  79. Solved: manual calculation for individual workbooks
  80. Solved: bloating of file
  81. Solved: slow to open a workbook
  82. Solved: Making my code smaller
  83. Solved: Different expressions of a simple formula
  84. Fully declaring each variable
  85. Solved: Is it possible to protect specific cells on the sheets,
  86. Un check a CheckBox when others are checked.
  87. Find shapes in sheet
  88. Solved: Pivot Table Help
  89. VBA userform calendar
  90. Vba code for importing external data
  91. Compare two columns for any one word
  92. Rich Text Format RichTx32.ocx found in \system32 but does not display
  93. Reference question
  94. mismatch error
  95. Logic assistance, please.
  96. screen up by code the option form (security tab)
  97. Still need help with this vba code
  98. comment autosize help
  99. Solved: VBA code to merge Worksheets Of Up To 1 Million Records In Ex. 2007
  100. Renaming sheet name
  101. Sumproduct formula help
  102. Scheduling servicing
  103. Help needed VB code - file name with dates
  104. Solved: Compatibility of Macros coded in 2007
  105. Hlookup returns wrong field
  106. Solved: How to change the index of an array
  107. excel to xml (problem with listed elements)
  108. Chart Object Disable Right Click
  109. Solved: Issues with Find
  110. Solved: Update Formulas to include added rows
  111. trying to add the new name of a file in a cell
  112. Solved: Count Dates in a Week
  113. Multi Criteria Macro
  114. XML in VBA
  115. Real Random number
  116. Fine tuning an If formula. Cells matching based on Condition
  117. Need help with vba code for deleting trailing spaces before or after an entry in a co
  118. Solved: Linking sub's and selecting cells for a sub
  119. Need Help testing if a cells contents match that of a cell in another column
  120. Solved: count dates in a week (continue)
  121. need help
  122. Solved: smilies in excell 2003
  123. Group with sum.
  124. Date Format issues
  125. Solved: Autofill Cells When Another Cell Has Value
  126. Solved: Is there an ISnumeric or Formula code
  127. Date format testing fails
  128. Solved: again problem with counting date in week
  129. Ini. Files problem
  130. Solved: Prevent users from editing every 'nth' row - eg every 3rd or 4th row.
  131. Solved: hi code tweeking
  132. Code for changing an entry to uppercase
  133. Right Click menu changed due to macro - how to modify?
  134. Formula for summing vertically based on horisontal condition
  135. Solved: if (RC[1]) = 1 then "=TEXT(RC[-1],""MMM/YY"")"
  136. Solved: Array Formulas Using CTRL SHIFT ENTER
  137. Solved: Sendkeys using wait.
  138. Solved: test selection for first and last row
  139. Change Col diff into Col letter
  140. Show Date And Time Of Latest Import From Yahoo! Finance
  141. Solved: Close workbook based upon cell value, but don't save workbook
  142. Solved: ANNIVERSARY YEARS
  143. mirror fill color from reference cell
  144. parse text
  145. changing cell contents on basis off another cell
  146. Access Report
  147. Solved: web forms/log ins + VBA?
  148. Copy Duplication
  149. Copy Data From WebPage To Excel
  150. Mail to macro
  151. macro to run a series of tasks
  152. Saving data in .dat format-help needed
  153. Solved: Checkbox issue
  154. UserForm - List Box Error Message
  155. Solved: One sheet dependent on input on another?
  156. Solved: CELLS W/ NO VALUE NOT EQUAL TO BLANK
  157. VBA Web Query Generating Error 1004
  158. Rename file excle
  159. vlookup match columns
  160. Include Row Number in XLFilterCopy
  161. Solved: Userform Calendar Control modification
  162. Solved: formula to extract number
  163. Solved: Lookup & transpose variable range from 1 To 3 columns
  164. Solved: Check cell for text
  165. Have predetermined data appear in one cell, when specific data entered in another.
  166. Solved: Locking down a spreadsheet
  167. Find for a specific word and extract details based on the found value
  168. Save columns A:D to C:\
  169. Copying new data from one sheet to another
  170. repeated action
  171. Solved: Open File on shared network drive and copy information to sheet
  172. Solved: Sum Dynamic row in VBA
  173. Track changes if array or multiple cells are changed
  174. Solved: how to condense results from multiple sheets
  175. Solved: Define range and combine two codes
  176. Solved: Making more checkboxes visible when a checkbox is checked
  177. Solved: Sumif with concatenate and wildcard
  178. Go To Dialog Box Width F5
  179. Solved: help with saving a program
  180. Solved: Accessing Cells With Activecell.offset
  181. Solved: UPDATE FORMULA
  182. Locking cells in different range
  183. Solved: Create new folder within VB
  184. Show messagebox if user selects locked cells
  185. Solved: vLookup like ?
  186. Mail merge where person and file name are the same.
  187. Locking blank cells only via VBA
  188. Import and split large tab deliminated text files
  189. adding a message box icon
  190. Solved: fill in every other row
  191. Excel to Power Point
  192. sending mail from excel via smtp-relay
  193. Value change with date
  194. Validating column Heads
  195. Linking Excel to Access Forms
  196. problem with date format when I use userform
  197. Solved: Specify 63 Days From a Date
  198. Code to Export as xml file
  199. Solved: Double Click a cell to show form with data
  200. Copy Data
  201. Check no selection in a listbox..
  202. Solved: VBA Message Box
  203. Incremental number for saved files
  204. Solved: Vlookuping a separate sheet
  205. Disable cut & paste in active workbook
  206. Solved: Names I define in a macro ignored by workbook?
  207. Solved: copying cell value only when calculated from formula
  208. Fastest method to read data from sheet
  209. Multipe Goal Seek across workbooks
  210. Solved: vlookup from another worksheet
  211. Solved: Compare the values between two columns
  212. dynamic Validation criteria
  213. Set bottom of variable range
  214. Solved: Message box ( Open Event)
  215. VBA Code Error
  216. Solved: Reverse Lookup Last Record Ignoring Location 300
  217. % movement tracker macro
  218. Solved: Create quarterly summary report from details
  219. Make file read/write
  220. Exporting Spreadsheets
  221. Solved: Column search returning wrong results
  222. Solved: formula simplificiation
  223. Frequency filter by date and sorted elements
  224. Solved: Last Row Array help
  225. Vlookup for all the row?
  226. Solved: Newbie once again, importing a module
  227. UserForm Initialize or Activate Conundrum
  228. Solved: Do ... loop
  229. Solved: Concatenate into a Single Cell
  230. Still need help with this vba code
  231. find duplicates entries
  232. Using VB with variables to access data from web sites
  233. GoTo versus Resume within an error-handling routine
  234. runtime error 1004
  235. Append to master list?
  236. Dynamically change number formatting within a column
  237. Help with code cleanup.
  238. Modify Macro to go from Ascending to Descending Order
  239. VBA Sub Procedures; Homework
  240. Advice and Tips for instr & for Findnext
  241. Dir function returns fileNames not as expected
  242. Solved: Help with For....Next, and some useful code for everyone
  243. VBA Help: Homework
  244. Concatenated Message Box: Homework
  245. Select Case Statements; Homework
  246. Solved: Help transfer excel table to access db
  247. VBA Case Statement verification; Homework
  248. Macro to hide blank rows in Workbook
  249. Variable column in code
  250. Solved: Copy Specific Cell in Rows and Columns to Another Worksheet