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