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