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 174

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