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. Formula Trouble
  2. Is it possible to auto-calculate as well as autopopulate a graph
  3. Macro for gantt chart update
  4. Solved: String Question
  5. VBA to find a directory
  6. copy data from excel to word without mail merge
  7. Solved: Non-VBA Solution: Identify Text String from Table and Return Text String
  8. Set to default browser
  9. Copy, Paste Special and Insert
  10. Solved: worksheet change event
  11. Solved: Detecting a Running Application
  12. trim & dates
  13. Solved: Copy based on multiple condition
  14. Code to print folders, subfolders and files
  15. Solved: VBA alternative to a look up table
  16. Solved: Calculation of an UDF
  17. What's wrong with this code?
  18. Excel 2007 find last column in table
  19. Make a cicle
  20. Solved: Challenging Question* Need excel macro to send email based on a choosen number
  21. Solved: Mysterious macro running on Excel file close?
  22. COMPARE 2 XL WORKBOOKS & PASTE DATA
  23. CTRL + Break
  24. Solved: Cells vs Range
  25. Rich Text Box
  26. Using wildcard in folder name
  27. [SOLVED] List data
  28. Solved: CheckBox Help
  29. Basic question on cell comparison
  30. Conditional formating of rows
  31. Scrollbar controlling several Textboxes?
  32. OWC11 Spreadsheet component Undo Error
  33. Lookup Macro Help
  34. Print active sheet from printpreview-excel 2007
  35. Solved: SUMIF attempting to interrogate cell properties in "criteria" portion of the syntax
  36. VBA Code to check if shared document is locked for editing
  37. If blank column, paste to the next column VBA
  38. Excel VBA for creating Folders
  39. request for complex examples for combination of function
  40. Solved: excel 2003 conditional formatting
  41. Refresh Sheet1 or workbook periodically
  42. Solved: Delete Row based on Column Criteria (with looping)
  43. populate combobox using array
  44. Add lines in excel comments through VBA
  45. Solved: When a row inserted, add one to highest Value in Col N, & add -1 to Col B value
  46. Print Visible data rows
  47. Can I block an .xlsm from being converted when it's open in Excel 2003
  48. "Out of Memory" error thrown when Formula contents length exceeded
  49. Solved: Programmatically naming an offset cell....
  50. Filter several pivot tables for same value
  51. Blank Columns
  52. Solved: Autofill formula VBA needed
  53. SOLVED: Send email using vbs without attachment
  54. Solved: Userform value problem
  55. count instances if within 30 days
  56. Get javascripts from a URL with VBA
  57. Detecting the class in a span
  58. Reading Data from Excel 2007 (?????)
  59. Replacing columns and rows default names
  60. Solved: Is it possible to enter a UDF into a cell and replace it w a native Excel formula?
  61. Collating data into a consolidated view
  62. Formula Update
  63. Solved: how do I save an xls as an xlsx after changes are made in VBA?
  64. Array help
  65. Solved: Need Zip code `
  66. Why doesn't this work in a loop?
  67. Compare one number with list of numbers
  68. VBA Module
  69. Modify code to run on multiple files
  70. Autofill issue
  71. Solved: What is wrong with this code???
  72. Solved: Cell Value As String
  73. Append data in master file from 4 different files
  74. Solved: Restrict Special Charachters
  75. Very complicated, copy and paste sheets in a loop
  76. Solved: Change Path -- ActiveWorkbook.path
  77. list all running programs
  78. Copy to last row with unspecified column
  79. Solved: Cell Reference
  80. excel connection
  81. Simple question...
  82. Sum columns in table excel 2007
  83. Copy Array of Values
  84. Problem with Changing formula
  85. Get Cells to flash based on a condition
  86. Solved: Adding conditional formatting VBA
  87. Solved: Message box for offset column
  88. Open Gmail
  89. Solved: Floating command bar position
  90. LOOKUP?? how to find data (stuck on project..please help)
  91. Solving a problem within VBA without using solver
  92. Solved: Delimiter saving each tab to its own .txt file
  93. HyperLinks to specific Location in another App.
  94. Solved: download complete
  95. Carriage Return Quote Delete Macro
  96. Solved: Emailing From Excel Using an Outlook Template
  97. Help from Guru needed
  98. Solved: get all the names in the column
  99. UDF randomize an array
  100. Macro to trim and convert in excel
  101. Solved: Print Settings
  102. Looping through workseets issue
  103. Solved: cutting date into variables
  104. Need quick help with some VBA issues (image sizing)
  105. Multiple If statements in 1 column
  106. Help With VBA in Excel ? Writing a function using probabilities ?
  107. How do I Insert 2 or more rows with a copy from one other row?
  108. Split Cell Content Into Two Columns
  109. Sharing a macro that is created by me
  110. Solved: What's wrong???
  111. A Short Formula Please - Excel
  112. iterate till equilibrium reached
  113. Solved: variable ProperCase
  114. Solved: Address
  115. Solved: Match Name find Row No then copy values to sheet2
  116. Solved: VBA Code, who can help?
  117. Solved: Embedded Spread Sheet
  118. Macro: look up another field and pull the data not matched
  119. Created a Drop Down Box based on certain criteria!
  120. Solved: InputBox Help
  121. Solved: How to Throttle SMTP Traffic
  122. How to delete a Empty column?
  123. problem with excel 2010 slicers
  124. Solved: Code for vba to replace below formula
  125. Solved: Data Validation List shortcoming(s)
  126. Form position
  127. Solved: How many substrings returned by Split() ?
  128. Solved: CNTL + N
  129. Solved: Total sum of Time in a column
  130. looking for value position in table
  131. Solved: caption SaveAs location
  132. on change event according to pivot table
  133. Does VBA Lose Variable Definitions and/or Values between Subs?
  134. excel - checkbox
  135. Solved: Label display
  136. Solved: conditional formatting
  137. Solved: Set Msgbox with Default number?
  138. Solved: Add a WebService reference to an Excel 2010 sheet
  139. Compare dtmDate with a value in column A
  140. Data Validation C2*D2 = E2
  141. Modifying Code for Whole to Flash
  142. Change all pivot table data sources
  143. Generating one .TXT archive from the Sheet.
  144. Solved: Activate certain sheet based on cell content
  145. Control Inputbox as number only?
  146. Copying the entire workbook to a new workbook
  147. Check Cell for Blank
  148. Solved: Macro's slowing down my spreadsheet
  149. Override the built in SAVE
  150. Application.Volatile Method
  151. Need some newbie help with Cell validation
  152. Solved: Click on protected sheet
  153. Reordering rows where sort is not effective
  154. set calendar to open at a specified date.
  155. Solved: Not sure how to fix this loop? Help Please
  156. Forgot the password I gave to protect a part of sheet
  157. Error: Object Variable or With block variable not set
  158. Userform Validation - Unique Names & Numbers
  159. Can anyone improvise this data and chart?
  160. Which FileFormat code (enumeration) for XL 97-2003 ?
  161. Data Validation - "A" and 2 number and 2 letters
  162. Solved: Fill by number of rows
  163. Macro: Need to find all unmatched Data
  164. Solved: Delete row if default value
  165. Assign Value to Variable Type Range
  166. Solved: slow macro
  167. how to use VLOOKUP only for blank cells in column A
  168. Excel VBA Access
  169. Lock Cell Format?
  170. Solved: Open workbook to last Friday of current week
  171. Solved: Unable to change the name of this cell
  172. Solved: display worksheets in combo box except...
  173. ref range to replace sheet name
  174. Solved: copy worksheet with referencing old worksheet
  175. Macro's for printing
  176. Convert String To Date
  177. Solved: General questions on excel objects...
  178. Messagebox to remind user of 12 day limit
  179. Solved: Loop with Go to steps?
  180. Getting a 0 When Dividing
  181. Loop through folder of Excel files and copy sheet from one set into another
  182. Macro: Move Cells where QTY is in upper percentile
  183. Solved: An error with setting a wb. Why?
  184. Solved: copy and rename sheet in sequential order
  185. Lock Cell after value updates to specific value
  186. Select sheets based on name
  187. Loop web query
  188. Solved: How to import multiple sheets from different files in same folder to main workbook
  189. Creating an OnClick event for an autopopulated userform
  190. Writing a .CSV file (.txt) from a Sheet
  191. Solved: Delete Row Based On Value
  192. Solved: Shortcut to run macro
  193. Set a value from different sheet in other sheet
  194. efficient way of comparing whats already in a collection
  195. Solved: Summing to a target
  196. Want to use vb YES/NO question box
  197. .xlsm row restrictions?
  198. Copy And Compare vs Switch And Compare
  199. xlt question
  200. Solved: Dynamic Procedure call
  201. Find and delete
  202. Embedded Spread Sheet - Span to next page
  203. Loop A Script
  204. Solved: Hide/Show Rows based on % character in cell
  205. Macro names changed in V2007
  206. Print Macro and Cell to Populate from table Help!
  207. Solved: Excel keeps freezing for about 5-7 seconds
  208. Solved: Excel VBA to select rows after Pivot Table
  209. VBA to automatically run
  210. Solved: Test for empty directory - odd result
  211. Solved: Formula to return latest date
  212. Solved: Display following year in combo box
  213. Can you force code to run in order?
  214. Eliminate unwanted data...
  215. Macro help!
  216. Split Text file data
  217. Solved: Why i get Vba Error in this code??
  218. Dynamic Array
  219. data validation - number or number / 2
  220. Solved: Calendar pop up with date AND time
  221. Linking 2 Combo Boxes Together?
  222. Not Sure How To Title This
  223. Font red and Bold specific dates returned on email sent.
  224. auto set page break to last row with data
  225. Solved: Making Scripts More Efficient
  226. Help on merging wbksheets
  227. Format Percentage Problem
  228. Excel Lookup Problem
  229. Can I use vba to set page breaks and fit the sheet’s data to 3 pages?
  230. Solved: Lose formula reference in active cell
  231. Read date and time from active cell to a date picker
  232. Solved: Display logo pasted to worksheet as icon on desktop shortcut
  233. Solved: Add name to combo box
  234. Solved: "If FileExist" isn't seeing the file
  235. dissable richt click page setup
  236. Hovering text not disappearing after click
  237. Solved: select previous sheet that I viewed
  238. Integer & String
  239. Solved: Relying on Exit Sub too much
  240. Solved: create notepad
  241. How to Lookup data from different sheets to single workbook
  242. Solved: IF Statement doesn't work
  243. Solved: Date format changing when pushed to SQL Server
  244. Solved: Delete rows if cells in multiple columns are blank
  245. Generating a simple report based on some criteria
  246. Remove conditional formatting but keep format
  247. Solved: VSTO
  248. User Form
  249. Change cell color from user form
  250. Solved: Clearing Pivot Cache