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