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. Solved: Drop Down Box Settings
  2. Send to DB code change
  3. combobox update
  4. Solved: Run Macro against a non-active sheet
  5. Turning an Array into a String and Vice Versa
  6. define last value in filter criteria
  7. ODBC to Access from Excel problem
  8. Google rank in excel
  9. Is it possible to avoid compile errors programmatically?
  10. Need to split a 6 digit number
  11. Solved: Macro not working correctly for different user
  12. calender where the date colors change
  13. Solved: Clear worksheet except for Row 1 Macro
  14. Solved: Call a function from personal.xlsb
  15. adding submenus to a drop down menu
  16. Working with hidden rows
  17. mqasimalihot - What are you up to?
  18. Very easy VBA problem!
  19. Making my full macro much faster
  20. Solved: Force save different name on WB open or save
  21. Solved: Change worksheet value to ensure data integrity
  22. Solved: Restrict mulilpe entries is N/A or No error is selcted
  23. Solved: If Statements
  24. Solved: Whole Numbers
  25. Comparison formatting
  26. Advanced Filter
  27. Solved: Compare two columns
  28. Problem with ' in filename
  29. Efficiency
  30. IF Date falls within a Month - Help!
  31. Combo Box - How???
  32. [SOLVED] Troubles with Counting Used Rows
  33. UserForms and Public Vars
  34. Solved: Excel freezes when code to add reference runs
  35. Worksheet_Change Query
  36. What is Application.Calculate
  37. VBA code to convert xls to PDF
  38. Solved: Mass Mailing Macro for excel and office 2007
  39. Editing a macro to display 0's next to a name
  40. Solved: Loop Through a UserForms Controls and Change TextBox Properties
  41. 2007 Chart not updating
  42. There has to be a faster way.
  43. Script to paste only values in cell- Excel
  44. Dynamic Field:= in Autofilter
  45. Solved: Loop through All Worksheets to remove Autofiler & Freeze Pans before close
  46. Solved: how to hide sheets for posting
  47. Paste selection to the first blank cell in a column
  48. Solved: Unwanted Microsoft message
  49. Solved: Routine to replace all cells with gibberish
  50. UsedRange
  51. Solved: Simplify this listbox code
  52. Cells Formatting for DATE
  53. Solved: size of sheet
  54. FTP Upload Advice
  55. ADO Recordset FetchComplete Event
  56. How to customize KBase sort routine?
  57. Solved: Syntax error
  58. Solved: multiple column vlookup
  59. Average of a Count in Pivot Table?
  60. Solved: Resize with Vlookup Help
  61. Digital signatures gets removed on a shared workbook
  62. Walking Through Many Subdirectories, Many Workbooks, Many Worksheets
  63. Define variable from cell value, append, and embed images.
  64. Required fields, validate on save
  65. Internet Explorer Automation Wait for HTML Tag to appear
  66. Send mail and avoid security message pop up
  67. Teaching coworkers excel basics
  68. Sleeper: Macro Slowdown due to Multiple Processes?
  69. Solved: List Box not linking!!!
  70. Solved: Restrict download area
  71. Chart data based on user input
  72. Solved: Invalid or Unqulified Reference
  73. Solved: Copying & Sorting
  74. Solved: Goalseek error
  75. Apply query to Recordset
  76. Solved: Embedded controls
  77. User Form
  78. Alter Code to show value in column 'A"
  79. Solved: Excel workbooks as a Database
  80. Problems with referencing a .xla file
  81. Solved: Import CSV & Ignore Items With No Text Qualifier
  82. Copy Autofilter Items
  83. CANNOT MADE CODE WORK
  84. Max and min values
  85. UPDATING NOW() AUTOMATICALLY
  86. Iterative copy paste problem
  87. Excel Solver Question
  88. Solved: Greater, Less than formula
  89. Help to enable VBA in excel 2007
  90. vba to automatically hit a key on the keyboard
  91. Code to show if cell interior colour is red
  92. Solved: paste value for filtered data
  93. Pivot table defaults
  94. Running Delete Row Code For All Tabs In A Spreadsheet
  95. Solved: remove signs (wildcards) from a string
  96. Solved: rename folder
  97. Help With/Code To Enable Macros . .
  98. count matching cell colors
  99. Solved: Need Windows Login of User who changed the data
  100. Or Function
  101. filter by dates
  102. Sender in VBA?
  103. Problem using "range.find" in VBA
  104. Solved: Lect combobox item, display wksheet name in listbox
  105. ftp upload
  106. Random Sampler
  107. Solved: separate rows with blank rows
  108. Need a macro to copy data to main file
  109. Solved: How to capture position info of a cell
  110. VBA help - code to loop through a certain folder structure
  111. Solved: Set Print Area - Last Row/Cell Used
  112. VBA cannot activate cell after first loop
  113. Solved: Excel Userform textbox's
  114. Solved: Adding a Treeview control to a Userform
  115. excel template error handling
  116. Get CSV from a PHP script on a server (mysql 5)
  117. UDF causes other macro to fail w/ err 1004
  118. find next blank row and input information from form
  119. Best Way to Loop Through Range?
  120. automatic spell check on open fields in protected document?
  121. get last cell value and add 1 for next number
  122. Solved: Set column width in pixels
  123. Pull out the values which are not Unique
  124. What is PERSONAL.xlsb??
  125. Auto Scale Chart Font in Excel 2007
  126. Removing HTMLCheckboxes
  127. Solved: Excel 2007: Bypass Workbook_Open Code
  128. Why is this ElseIF not the same as this Select Case?
  129. Autofilter On One Column?
  130. Copying from one file to another
  131. VBA
  132. Excel to PDF
  133. VBA
  134. Change cell color to color of adjacent cell
  135. Solved: repopulate formulas
  136. Solved: positioning a Chart
  137. Excel generate a task in Outlook
  138. Find all xls files except one subfolder
  139. Frequency function and open intervals
  140. retentive variable
  141. To random_noise
  142. Solved: Need help with toggle button
  143. Working with Charts
  144. Finding a Value
  145. Find the next date in column
  146. populating combobox at runtime
  147. Error: Excel cannot complete task with available resources???
  148. Solved: Text-to-column but right to left
  149. Error Copying Data
  150. Checking Tab Names
  151. Import Address Book from Outlook
  152. [SOLVED] Solved: Selectively copy ActiveCell onChange
  153. Solved: Save as & file name\path problem
  154. Solved: vlookup with multiple criteria
  155. Solved: Filtering records older than one year ago
  156. Solved: Date formula in vba
  157. detect more than one border color along single edge of range
  158. Trendline data/info
  159. How to access the methods of .xla from VBA?
  160. copy & paste
  161. Solved: script to copy multiple cell values into one cell
  162. [SOLVED] Shifting rows to a worksheet depending on a cell value
  163. userform apply code after userform end
  164. Will deleting defined name delete data??
  165. Removing pictures
  166. Deleting words in a string
  167. Validating Textbox's on Worksheet using Class Modules`
  168. Group and filter the data
  169. Solved: accidently save over file
  170. Insert Chart Help Needed
  171. Hidden Module?
  172. Column values based on entries on another sheet
  173. Solved:
  174. Solved: VBA userform
  175. What Does This Mean??
  176. conditional formatting based on date?
  177. time sum
  178. Solved: run DOS command without waiting ?
  179. Solved: Extract Text to columns
  180. SeriesCollection by name
  181. Solved: Deleting / Reordering columns in a Worksheet
  182. Solved: .formula not working with Excel
  183. Vanishing controls...
  184. Solved: Working with Shapes
  185. Code to copy and insert rows
  186. Pulling folder content file info into worksheet
  187. Solved: Check date & compare to another date
  188. Excel to SQL Server
  189. Query Table in Excel
  190. Faster method for VLOOKUP
  191. Solved: Sending Copy of WorkSheet from 1 Book to Another
  192. Solved: all caps combo box
  193. Highlight Row Based on Cell Value
  194. Highlight cells that did not match
  195. Solved: Bar Chart doubt
  196. display range value in message box
  197. automatically populate userform from row selection in excel
  198. Input more than 15 digits numbers in a cell in a worksheet
  199. How to Calculate Tax from Net Amount--Help
  200. [HELP] Merging all the details of the work book in one sheet.
  201. Problem with ComboBoxes (control toolbox ones)
  202. need some code to move items into new sheets
  203. Excel to PDF
  204. Solved: search next value with textbox
  205. TAB Name
  206. Extra Information alongside Pivot Table
  207. Excel chart in PowerPoint
  208. Solved: Regression Analysis macro
  209. [SOLVED] Trying to get Code to run in excel 2007
  210. Solved: search next value with textbox in other sheet
  211. First date in week from <WeekNo, Year>
  212. Order an array from the smallest number to the biggest
  213. Format Cell For Time
  214. Fairly simple problem
  215. Survey in Excel using Visual Basic Need to edit!
  216. Dynamic pivot charts using pivot table
  217. Is this something that I can do in VBA?
  218. Speed up loop?
  219. update procedure in excel file from personal.xls
  220. Open Template with file picker
  221. Limit amount of rows formatted
  222. "INDIRECT" worksheet fuction problem
  223. Solved: Return default save path for an excel add-in
  224. string manipulation problem
  225. Solved: I'm having trouble selecting a range
  226. Solved: BeforeDoubleClick Issue?
  227. Solved: count all equal combinations
  228. Calculating An Average
  229. Solved: Combine Data into one Cell
  230. Drop down List
  231. Summing Similar Conditons
  232. Help uploading excel cells into website
  233. Inserting a Range on a Chart as TextBox ?
  234. Count Files in Several Folders
  235. Solved: Auto fit columns in whole workbook
  236. Formula to Prevent a higher % to be entered...Help
  237. Solved: open access and run macro in access
  238. Date Format
  239. Solved: Text To Columns - passing FieldInfo value as a string
  240. run code from personal.xls
  241. Solved: Code Amend to OK Msg Box Before Close
  242. Write to a text file
  243. Conditional formatting
  244. Solved: make visible based on value
  245. modify nextrow code
  246. Error Msg: MS Office is waiting for another application to complete an ole action
  247. 2007 Pivot Table Conditional Formatting macro problem
  248. Can’t Find Project on Library . . .
  249. Transform data to Columns
  250. Image Popup when mouse arrow is on Button